Log in

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 167 168 169 170 171 172 173
  1. Solved: Subsciprt out of Range Error with Mulitple Workbooks (3 replies)
  2. ReadOnly Column (7 replies)
  3. Copy to closed wbk (3 replies)
  4. Solved: Need help with Click Event of OptionButton / CheckBox (3 replies)
  5. [SOLVED:] More efective sumproduct (2 replies)
  6. Solved: VBA code to copy rows from one sheet to another based on 2 criteria? (15 replies)
  7. Apply only the Font part of a Style (3 replies)
  8. Solved: find blanks= 0 (10 replies)
  9. Inserting, Renaming and Moving/Sorting Worksheets (2 replies)
  10. Solved: paste from multi sheets to 1 (3 replies)
  11. Change the Background Color of button added to worksheet using vba (2 replies)
  12. Solved: Selecting subtotal and grand total cells only(not entire row) (13 replies)
  13. Solved: Copying Formula Results (11 replies)
  14. open/activate book and edit without readonly -query (26 replies)
  15. Word frm to Excel (8 replies)
  16. Solved: Unusual Error Trap (7 replies)
  17. Macros match / Lookup (3 replies)
  18. Need help clearing (removing) buttons (2 replies)
  19. Apply macros on filtered columns (2 replies)
  20. Solved: Where to put additional code (11 replies)
  21. Loop into Excel (6 replies)
  22. Error when Export data into Excel (1 replies)
  23. Solved: Get values from cell with VBA (3 replies)
  24. Lookup Nth occurrence: cells formats (6 replies)
  25. Solved: Code Select Sheet & Range single step (2 replies)
  26. Help with macro to copy and paste based on formula result (5 replies)
  27. Insert Photo in Cell, using Userform (3 replies)
  28. Solved: Command Button Naming (3 replies)
  29. Solved: calculation (2 replies)
  30. [SOLVED:] Opening another file with title equal to a cell entry (2 replies)
  31. Solved: Loop through sheets (6 replies)
  32. Solved: Moving data to a Word document (22 replies)
  33. Transferring data from an array to a range - strange error (8 replies)
  34. Solved: Updating an access record from an excel userform (excel '97) (24 replies)
  35. top 5 and top 10 (4 replies)
  36. Solved: disable calculation (2 replies)
  37. Solved: Shifting rows to the right. (1 replies)
  38. Trouble Looping to eliminate multiple data (5 replies)
  39. Solved: Validating entry on a userform (Excel '97) (6 replies)
  40. Replace fonction vba (1 replies)
  41. Solved: How do I copy and insert rows (2 replies)
  42. How to find an error in my VBA !! (6 replies)
  43. counting data (4 replies)
  44. Formatting of data from text file into Excel File. (10 replies)
  45. days of the week (7 replies)
  46. code does work at home but not at work >< (1 replies)
  47. Error Checking for EOF / BOF Debug (1 replies)
  48. Solved: Show asterisk(****) in password VBA code (1 replies)
  49. Find function (7 replies)
  50. Solved: Only save with a Macro Button (2 replies)
  51. how to use vara function in vba (7 replies)
  52. Solved: Clearing Clip Art (8 replies)
  53. Solved: Naming a File (5 replies)
  54. Solved: Count Files in folder &amp; cell.value=NewFile.Name (8 replies)
  55. Solved: Error '1004' pops up randomly (3 replies)
  56. Hide / Unhide toolbars for a particular worksheet (8 replies)
  57. check for the values in the sheet 2 and count the values (11 replies)
  58. Solved: Merge Workbooks (6 replies)
  59. How to automaticlly disable a spreadsheet after a period of time (3 replies)
  60. Export Problem (2 replies)
  61. Error: 1004 (4 replies)
  62. [SOLVED:] Code added by VBA ends up on wrong sheet? (2 replies)
  63. Solved: Macro will not save (31 replies)
  64. Deleting all rows of named merged range (5 replies)
  65. Solved: Convert number to letter (16 replies)
  66. Last non-blank cell in a row or column (2 replies)
  67. Pop Messag Box required if value is different (2 replies)
  68. Updating external reference of a picture (0 replies)
  69. Hide/Uhide rows without macro (2 replies)
  70. Dynamic Group by, with Subtotal and Grandtotal (6 replies)
  71. UserForm;ListBox Select show Picture (7 replies)
  72. User Form Looping Problem (18 replies)
  73. Solved: should work but doesn't - application.inputbox problem? (3 replies)
  74. Unhide based on Calculate event (7 replies)
  75. Worksheet_Calculate() Multiple Ranges (2 replies)
  76. Create a working CommandButton in a Userformusing VBA Code (23 replies)
  77. Macro Help (11 replies)
  78. force enable macros (9 replies)
  79. Solved: DAYS360 function within VB (3 replies)
  80. Basic FTP upload problems please help, kinda urgent? (11 replies)
  81. Merging text from selected range of cell (16 replies)
  82. Solved: substitute &quot;.&quot; with &quot;&quot; and give format (21 replies)
  83. Solved: Checkbox with userform (3 replies)
  84. Solved: Problems with GetOpenFileName (4 replies)
  85. Solved: But it was working 5 minutes ago.... (8 replies)
  86. Phantom MsgBox (12 replies)
  87. Solved: Pagesetup.PaperSize (2 replies)
  88. side by side stack charts (10 replies)
  89. Sleeper: Sum rows based on column criteria (1 replies)
  90. Solved: Excel ShapeRange.Align (1 replies)
  91. Open all files in a directory and merge to one file (10 replies)
  92. CASE Statement type mismatch (2 replies)
  93. Passing a value to another sub routine (4 replies)
  94. VBA can not use Mshflexgrid.ocx SP6 (1 replies)
  95. Next With out for error (4 replies)
  96. Get a value from a cell (3 replies)
  97. Values used for multiple button clicks (3 replies)
  98. Solved: copying comments (9 replies)
  99. Solved: Finding local maximums in same cells on many sheets (21 replies)
  100. Conditional colouring (6 replies)
  101. userform toolbox (11 replies)
  102. row selection (18 replies)
  103. SUMIF or Vlookup - How to use in with Range Offset (5 replies)
  104. Solved: UserForm;ComboBox;FilterData (5 replies)
  105. Solved: Help Matching String Patterns (5 replies)
  106. Solved: default macro (9 replies)
  107. Solved: Compare Cells within same row for whole sheet (11 replies)
  108. Addin References (2 replies)
  109. value for a specific zip code (4 replies)
  110. Solved: Linestyle constant values (3 replies)
  111. excel failed to access some objects. (8 replies)
  112. macros on web (1 replies)
  113. [SLEEPER:] The code works, but the address is "WEIRD" (6 replies)
  114. Select Case with multiple dependencies (2 replies)
  115. Solved: Unwanted Events firing (3 replies)
  116. Qty and Time based lookup (2 replies)
  117. Fit Table content (1 replies)
  118. Solved: Selecting last row of an active column using a single macro (4 replies)
  119. Solved: Date Formula (2 replies)
  120. Solved: Excel generate calendar appointments in Outlook. (26 replies)
  121. Speeding Up HTML Table Import (2 replies)
  122. highlighting minimum and maximum values (6 replies)
  123. Solved: Reversing the order of rows??? (1 replies)
  124. 'Update Values: datasheet.xls' problem (2 replies)
  125. Inserting Hyperlink Diagbox Value to Text Box (6 replies)
  126. select column by referencing column title (2 replies)
  127. Unable to register/reference DLL (3 replies)
  128. Solved: User Form question (4 replies)
  129. Solved: Help with formula please (2 replies)
  130. [SOLVED:] Shortcut assign (2 replies)
  131. Set the Workbook_SheetChange to False ?? (12 replies)
  132. Slow Save, and the File Size Kid. (4 replies)
  133. On Key events (3 replies)
  134. Restrict Cell entry to minutes and seconds only (9 replies)
  135. Automatic alphabetic scrolling in a listbox (5 replies)
  136. Inserting image to Cell from User Form (1 replies)
  137. Staff planner- Got more ideas from my employer (6 replies)
  138. Lock OLE Excel object (VB6) (4 replies)
  139. Controlling where cursor goes to next after using Enter key (2 replies)
  140. Updating graphs based on choice in drop-down menu: (2 replies)
  141. Use SQL to fill Data Valadation list box (5 replies)
  142. Solved: Active cell highlights row (16 replies)
  143. "For Each" an endless loop, any better ideas? (3 replies)
  144. Help to Fix Program in Iraq for Troops (3 replies)
  145. protecting multi shts with separate pwrds (10 replies)
  146. UserForm:ComboBox1 select show and change data ListBox and ComboBox2 (6 replies)
  147. Solved: Emergency...gross margin algorithm! (9 replies)
  148. Skip Confirmation Prompt while saving Excel file as htm through VBA code (1 replies)
  149. activeworkbook.name space (1 replies)
  150. loop through visible pivotfields , copy to new sheet (5 replies)
  151. Solved: Custom Function for Dups (2 replies)
  152. [SOLVED:] Blank Cells and Filling Down R[-1]C (9 replies)
  153. Using LOOKUP in VBA (4 replies)
  154. Solved: Different Functions In Same Subtotal Row (17 replies)
  155. Solved: If command (2 replies)
  156. Count occurrences in specific column (9 replies)
  157. Solved: Excel 2003 - VBA Userform help (7 replies)
  158. Challenge manipulate Pivot-table from cell ranges (12 replies)
  159. How to increase the speed (3 replies)
  160. copy contents of each Workbooks with Different data ranges from a Single Folder (3 replies)
  161. Rich Text (3 replies)
  162. Transfert fron cell with condition (2 replies)
  163. Solved: Subtotal Method of Range Class Failed (7 replies)
  164. Rename multiple files (add datestamp)? (7 replies)
  165. MsgBox and Input Box Macro (6 replies)
  166. Vlookup result into a textbox - Help!! (3 replies)
  167. objIE.Document.all("btnEmailConfirmation").Click , 1 (2 replies)
  168. Combining IF criteria in DO LOOP (3 replies)
  169. Solved: VBA VLookup Help (Excel '97) (16 replies)
  170. sh.Name (4 replies)
  171. sheet and workbook called "ii????.tmp" (8 replies)
  172. Sleeper: Timeout (3 replies)
  173. Solved: too many buttons (2 replies)
  174. Using VBA to sort data (1 replies)
  175. Command Button to extract data from UserForm (7 replies)
  176. Put code WS modules not a General module?? (5 replies)
  177. Solved: VBA Sort using the Left 7 Charaters (3 replies)
  178. Variable Filename in Macro to SaveAs (3 replies)
  179. Solved: charts (2 replies)
  180. Arrays, searches, and replacement (4 replies)
  181. combobox in an addin (1 replies)
  182. i have a problem with my user defined class (3 replies)
  183. Solved: working with Dates (3 replies)
  184. Adding and removing Excel menu buttons (2 replies)
  185. Solved: Startup template not used after 2007 Install (2 replies)
  186. Pivot Table Drilldown (2 replies)
  187. Solved: IF...Then...Else (5 replies)
  188. looking up text and cell fomat? (1 replies)
  189. Vlookup or Match? Copying data from one sheet to another. (5 replies)
  190. Customising Comments (3 replies)
  191. Keeping data the way it should be... (23 replies)
  192. Solved: Indirect using row numbers. (2 replies)
  193. [SOLVED:] How to hide the sub popup menu (13 replies)
  194. 1000 row filter (5 replies)
  195. userform (7 replies)
  196. Error when file to save is already opened. (3 replies)
  197. Select a record from a combobox and add data to to the selected record row. (5 replies)
  198. Solved: Finish Data update before rest of macro runs (6 replies)
  199. Paste Screenhots (2 replies)
  200. Please help - writing simple formula in VBA (3 replies)
  201. Align shapes within cells and fix their position (1 replies)
  202. Solved: Summary using VBA (3 replies)
  203. Solved: Help with For Each...Next please (3 replies)
  204. cell within range reference (4 replies)
  205. Very Beginner Question Excel 2003 or 2007 (21 replies)
  206. UserForm ComboBox (4 replies)
  207. UserForm within procedure - help (1 replies)
  208. Worksheet macro (10 replies)
  209. Solved: UserForm Entry Cell to Change Colour (2 replies)
  210. Multipage Control in UserForm (4 replies)
  211. Solved: Format Cell Question (1 replies)
  212. Solved: VLOOKUP Problem formula not vba (10 replies)
  213. Count rows which meet three conditions ??? (7 replies)
  214. PDF Printing (0 replies)
  215. Error 2147417848 (80010108) (3 replies)
  216. SOLVED: simultaneous searching (26 replies)
  217. Substitute Macro using a lookup column (7 replies)
  218. Convert Cols into Rows (9 replies)
  219. refedit range comparison (7 replies)
  220. Solved: create multiple folders from worksheet (4 replies)
  221. New Instance of InternetExplorer (1 replies)
  222. Solved: If formula result is Zero then Blank (3 replies)
  223. Copy and paste after looping (7 replies)
  224. Simple date validation (7 replies)
  225. Solved: Macro Help (20 replies)
  226. Button Extraordinaire (0 replies)
  227. Using a Range name as part of a function (7 replies)
  228. Big IF Loop Question (8 replies)
  229. Solved: Saving single page from multiple workbook (4 replies)
  230. conditional formatting by text colour (8 replies)
  231. personal.xls (9 replies)
  232. Solved: Group Data to another Cell (5 replies)
  233. Copying from one sheet to another and choose samples (10 replies)
  234. Solved: How do I run a macro in a form module from a class module (23 replies)
  235. Solved: Why does this not add borders to the textbox added on the active chart? (7 replies)
  236. Copying data from a series of Excel files. (8 replies)
  237. sound with vba (6 replies)
  238. Copy Code from Module2 to Module1 (8 replies)
  239. Using refedit in named range (6 replies)
  240. Solved: 12 month Update Code (21 replies)
  241. Solved: Use named range with combobox (3 replies)
  242. Solved: Error Handling Question (3 replies)
  243. Solved: Faster way to Trim() ??? (18 replies)
  244. Solved: rand numbers (3 replies)
  245. Delete formulas when unprotect (7 replies)
  246. Trying to write to embedded OLE Excel sheet in VB6 (1 replies)
  247. Solved: Copy/Paste cells into new sheet based on value list in 3rd sheet (4 replies)
  248. Adding checkboxes to forms at runtime (2 replies)
  249. Conditional Formatting (11 replies)
  250. Solved: R1C1 AND Letters - is there a way to see both (2 replies)