PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 [23] 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166

  1. Msg Box options
  2. Solved: option box, combo box and excel
  3. Solved: form.width=screen.width
  4. Solved: Newbie...Stopping automatic conversion to scientific notation in VBA
  5. Solved: Showing all offset matches on different sheet using formula?
  6. Summing last two entries or smallest two entries in a list
  7. complicate unhide sheet
  8. Solved: Replace in a sheet and not the entire workbook
  9. Moving 3 decimal places
  10. Simplify SQL string
  11. Solved: use today in formula
  12. Solved: Insert/Delete Row Between Entry
  13. Hide Rows Using Data Validation
  14. 2 Excel Files, 1 Userform
  15. Solved: UserForm scroll bar
  16. Solved: Open text File into a Excel workbook
  17. Solved: Named range quickie
  18. Solved: filtering, maybe?
  19. Solved: Excel out of memory with plenty of memory unused
  20. Print Userform
  21. Copying data from another excel workbook created to another file automatically.
  22. Manipulate data in range
  23. Solved: populating listbox2 with listbox1
  24. Determining name of nested multipage...
  25. Highlighting cells using VBA & Sumif()
  26. Auto close excel after 1hr
  27. Solved: Insert File(s) In to the main xls file
  28. Solved: Display info from Module in msg box
  29. Solved: 52 wks or 53 wks in Year
  30. Solved: Test if last column is longer than first column
  31. Solved: Autofit alternating sizes
  32. Execute SQL Stored Procedure
  33. VISTA: multiple excel apps
  34. copy and paste 2 destinations
  35. Solved: Add Bold to Number Formating
  36. Solved: populating a worksheet
  37. Solved: Call Subroutine to Clear cells on Worksheet_Change
  38. Assigning comments to UDF
  39. Solved: List worksheet names across columns
  40. Count rows based upon multiple criteria
  41. Reassign variable
  42. count if help
  43. Solved: Max and Min dates in right header
  44. Unload frm1 - error (Wrong Number of Arguments)
  45. This Should be an easy copy/paste
  46. ensure that all controls have a value
  47. Solved: Stop WorksheetChange Event
  48. Excel Help - Templates / Forms
  49. Solved: Drop Down List
  50. Solved: deleting form listbox and datagrid
  51. textbox controlSource problem
  52. double V-Lookup
  53. Solved: Delete Rows
  54. Top 5 Help.
  55. save userform and continue later
  56. automatic calculation
  57. Solved: Match
  58. Flexible range graph
  59. API show last active URL
  60. Solved: Return a subtotal in a list
  61. Update Registry key via VBA/excel to chnage default E-mail to Lotus Notes
  62. Retrieving hidden columns
  63. Adding filter criteria
  64. Solved: Generate a computer's hardware code
  65. Display sheet name in a cell
  66. Solved: Macro to compute Lagged Correlations
  67. Solved: Enable additional controls by vba code
  68. Down and Dirty xml->xsd
  69. automatic save a file and close
  70. vbe and excel date settings
  71. Solved: Option button and text box
  72. Solved: Open workbook when excel starts
  73. a userform question
  74. Solved: Apply a Range Name to a second sheet
  75. PERSONAL.VBO
  76. Solved: Problem Moving Code from Module to UserForm
  77. Macro code isn't working
  78. Solved: dsiplay image based on list box selection
  79. Warning for missing information
  80. Solved: Calculating wage using time format & currency format?
  81. Solved: Import Text File
  82. Help in Tab in user form
  83. Embed ActiveX Control for portability
  84. Solved: Input check
  85. Solved: User defined data type - array of an array!
  86. Link VBA and HYSYS
  87. Solved: how range is defined for a worksheet?
  88. Solved: Get values from a multi columns listbox
  89. XLM Page Setup
  90. Solved: search for #n/a
  91. Is this ready?
  92. Solved: Create folders on network drive
  93. Solved: Listbox selection
  94. XY Scatter graphs
  95. Chart Problemz
  96. Solved: 1st Form option button to 2nd FORM
  97. Linking?
  98. Solved: Copy & paste a cell and row times defined number
  99. Solved: subtract
  100. Solved: Keep only the newest data?!?
  101. Copy rows from multiple worksheets
  102. Selecting Range based on criteria?
  103. Solved: Selecting Range based on criteria?
  104. Solved: Combo Box help
  105. Solved: Date Formula With Conditional Formatting
  106. Using OWC9 spreadsheet on User Form
  107. Solved: Setting a range from a Worksheet module
  108. HELP!! Attachments to email - excel VBA
  109. Solved: Save one sheet as Read-Only
  110. Solved: Get a Full address of a website using a macro
  111. Solved: Collating and formatting financial data
  112. Excel 2007 -- need help
  113. Form-level key handler
  114. Multiple V-look ups at once
  115. Solved: run if this cell is blank
  116. Tracking payment adjustments
  117. VB date formats - UK / US - HELP!!!!!
  118. Solved: Counting Visible Sheets in a workbook
  119. Solved: use multipage as button
  120. Select all text of a textbox
  121. new to VBA scripting. need help.
  122. V Lookup
  123. Solved: Run-time error '3464' Data type mismatch in criteria expression?
  124. Help with: Hide empty rows, unhide others from johnske
  125. Solved: Advice On Macro For Transfering Data
  126. File I/O Functions
  127. Solved: Ignoring 0 in list
  128. Solved: reducing file size
  129. Solved: Date Format
  130. Solved: Cell Error ####
  131. Solved: Building Dynamic List for Combobox Sort Alphabetically?
  132. Scanning for specific sheet names
  133. Find used cells, skip blanks
  134. Excel VBA Problem :(
  135. how to save worksheets in another excel file?
  136. Solved: rounded down format/display
  137. Conditional Formating
  138. Solved: Pasting from Word into Excel
  139. hide or disable a page
  140. Solved: Excel sync from network copy
  141. Naming a Worksheet Today's date
  142. Alter one macro from within another
  143. Solved: output message in label
  144. clock - display message every half hour
  145. Solved: how to write the codes?
  146. Solved: Install if certain user
  147. Solved: turn off features if not found
  148. Misc problems and questions.
  149. Run macros on different occasions
  150. Concatenate in a cell the content of a column if a certain condition
  151. See the values from a formula
  152. VBA paste from clipboard to email
  153. Solved: Saving Sheet
  154. Solved: Comparing 2 Sheets in a Workbook minor bug
  155. Solved: Sort without a title row
  156. Consolidate to Summary Page
  157. Solved: filling in data, relative to the active cell
  158. Sorting Multiple columns programmatically
  159. Solved: Show Hide Multiple Columns at once
  160. Hide and unhide rows by selecting a letter from a userform ComboBox
  161. Another minor Bug :( passing String variable
  162. Variable Indirection
  163. Waiting message
  164. Enumerate reference GUID's
  165. Solved: Check if sheet is blank
  166. Solved: Referencing A Variable + An Integer To Show Cell Value?
  167. how to delete rows?
  168. set label value equal to file name
  169. Array.Count gives Invalid Qualifier Error
  170. Solved: autofilter event ... ?
  171. Solved: Range Array
  172. Urgent - manual combo input
  173. Add ColumnHead to a ListBox via VBA
  174. Find First Cell, Check if Pivot Table
  175. Help in pictures on user form
  176. AfterUpdate event in Class module
  177. AutoFilter - number of criteria
  178. Solved: Conditional Range without autofilter?
  179. Why my UserForm cannot be initialized?
  180. Solved: Excel to Access
  181. replace an icon
  182. Merge tables on diferent workbooks
  183. Statistics on LogNormal/Monthly Arrays
  184. Praying... and Praying....
  185. Solved: Worksheet_change event with VLookUp
  186. Solved: Formula question
  187. Solved: What's up with thes CheckBoxes and Option Boxes?
  188. Speed Imporvements
  189. Trigger Excel Solver without VBA
  190. Solved: Formula not working the way I need it to
  191. Solved: Display Character Entries in InputBox with "*"
  192. Excel VBA "OnKey" command problem
  193. Block cells
  194. Solved: error
  195. Custom Menu Item not following document
  196. Trigger Excel Solver by User Defined Function
  197. Check availability
  198. % formula
  199. Solved: workout
  200. Changes from vba version 6.3 to version 6.5
  201. Another Related Question/Issue (combining workbooks into Master file)
  202. a udf with many arguments
  203. Problems freezing the header row form scrolling
  204. Solved: Adding Icons to Add-in
  205. Solved: Drag Over Event for Cell Color Format Properties
  206. Solved: Add Input box to this code
  207. Solved: Create an Array from a Filled Range
  208. code failure
  209. Solved: Mark minumums by columns in each segment
  210. Solved: Macro: Cell Formatting is Failing
  211. Solved: colorindex = xlnone ?
  212. Solved: Sort Left to Right
  213. Current Account Program
  214. Solved: Need help implementing code
  215. Solved: Hiding the "X" or close button on user form
  216. Sum text box values
  217. add an item to a vbe toolbar
  218. Print to 1 pages wide sometimes makes it too small
  219. month
  220. Lookup result needed
  221. Solved: ordering complex dates
  222. Sumif & sum only positive or negative number
  223. Solved: Hiding Worksheets
  224. show answer to other cell
  225. how to put the sheets in order?
  226. how to open a sheet instead of another sheet?
  227. code for determining error in s/sheet
  228. Switch to tab if already created
  229. row height set up
  230. updating links to external data source
  231. how to load textbox?
  232. Solved: Run macro after file save
  233. Settle Time for Excel Application
  234. write in cells in correct order
  235. open an image inserted with hiperlink
  236. IF statement inside a vlookup?
  237. Sorting data over multiple sheets into array
  238. Solved: Find blanks - move over and then highlight
  239. Export to Txt File - Amount should be right justified
  240. Macro to delete other macro or Module
  241. Solved: Highlight date if it is two weeks late
  242. Solved: Sheets(Array(1,2,3).Copy based on date?
  243. How can I do this?
  244. Solved: Requisite first posting to view attachments
  245. list box
  246. Excel VBA to server
  247. remove Pivot lookup value
  248. Solved: Create an Array from Filled Range - Part II
  249. Check Lotus Notes if open
  250. Solved: Splash Screen