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 174
  1. Change to "SKIP BLANKS" when pasting? (2 replies)
  2. Checkbox checking...then unchecking on its own? (1 replies)
  3. Microsoft Query hangs (4 replies)
  4. Multi-condition function (11 replies)
  5. Solved: Automatically import data from Access DB in Excel (5 replies)
  6. Solved: Assistance with character counting (Excel '97) (9 replies)
  7. problem deleting rows based on a condition in another workbook (6 replies)
  8. Opening embedded word document through VBA (4 replies)
  9. Solved: naming sheet after cell value (6 replies)
  10. Sleeper: Copy rows to worksheet two (10 replies)
  11. Solved: Run time error 424 - object required. Why? (2 replies)
  12. Solved: Speed up or new code for deleteing rows (6 replies)
  13. [SLEEPER:] VBA Code for clicking a link? (2 replies)
  14. specifying range when returning an array (3 replies)
  15. Solved: Please help with this Code (5 replies)
  16. Solved: Excel Graph w/cubic function (4 replies)
  17. Solved: delete trailing empty rows from 2d array (2 replies)
  18. Solved: VLookUp Error in VBA (10 replies)
  19. Solved: Hide range of column on sheet2 from sheet1 (2 replies)
  20. Excel VBA Code Help!! (3 replies)
  21. Cut Copy Paste disable in Excel 2007 (13 replies)
  22. Solved: Create button which is always shown in excel (6 replies)
  23. Vlookup in vba (3 replies)
  24. ComboBox;Filter value (4 replies)
  25. progress box (3 replies)
  26. Solved: in Excel 2007, pasting to visible cells only (12 replies)
  27. Solved: VBA not reading .Value (8 replies)
  28. Solved: Shifting rows???? (4 replies)
  29. [SOLVED:] I need help referring to last and first sheets (3 replies)
  30. Solved: Macro to make duplicates to be displayed in one row (11 replies)
  31. Solved: Add Sub-Folders (7 replies)
  32. Solved: “Move Select After Enter” Problem (3 replies)
  33. problem comparing rows and copying result to another sheet (6 replies)
  34. Solved: Cut and paste into new sheet (23 replies)
  35. isnull problems (1 replies)
  36. Solved: Merge rows with same Info in to one (4 replies)
  37. Solved: Secure workbook by finding a file (6 replies)
  38. Sleeper: Moving data from rows to adjacent columns (1 replies)
  39. MultiSheet Print Preview not including Charts (7 replies)
  40. Method 'Select' of object '_Worksheet' failed (4 replies)
  41. Solved: Column Values Duplicate (6 replies)
  42. Delete an Access table using vba (3 replies)
  43. Solved: If Question (14 replies)
  44. Solved: DSUM (14 replies)
  45. excel add-in document properties (1 replies)
  46. Modify "Errors (1 replies)
  47. Solved: Comma Delimited Data Arranging (4 replies)
  48. Color Rows or Colums (6 replies)
  49. running a macro on an otherwise protected workbook (4 replies)
  50. Showing and Hiding a picture (15 replies)
  51. Empty cell in a selection (8 replies)
  52. Dim array in userform (9 replies)
  53. Import the text file data into different worksheet of xls based on certain value. (1 replies)
  54. Passing variables not working (17 replies)
  55. like comparason (3 replies)
  56. Solved: AutoFill Macro (5 replies)
  57. Solved: Universal error trap (17 replies)
  58. Solved: CSV Files (3 replies)
  59. Please Help W/Conflicting Codes (3 replies)
  60. Solved: OLEObject Click Event (2 replies)
  61. [SLEEPER:] Help tidying up some current code that causes errors (13 replies)
  62. How to use IsMissing when the optional parameter is integer? (9 replies)
  63. "Enter" textbox upon UF initialize (12 replies)
  64. Update data from text file in worksheet starting at particualr cell. (2 replies)
  65. Solved: Shifting cells to the right???? (3 replies)
  66. Inserting Pic with other Data Entry Field. (0 replies)
  67. Extract all workbooks cell names and formulas in a spreadsheet (5 replies)
  68. Solved: Insert URL Image (1 replies)
  69. Solved: Merging columns (4 replies)
  70. How to pass an Array in a Class Module? (7 replies)
  71. Newbie needs help with "slideshow" macro (4 replies)
  72. Simple VBA question (2 replies)
  73. Download a txt file from Website using excel (5 replies)
  74. Sleeper: Help W/AutoFilter (1 replies)
  75. Solved: How to subtract cell values (12 replies)
  76. Solved: Help w/ simple 'For-Next' loop (11 replies)
  77. range to array (1 replies)
  78. Compare Numbers Strings Using VBA (multiple criteria) (12 replies)
  79. Run Time Error 13 Message, very strange ! (4 replies)
  80. listBox Issues (2 replies)
  81. Solved: Subsciprt out of Range Error with Mulitple Workbooks (3 replies)
  82. ReadOnly Column (7 replies)
  83. Copy to closed wbk (3 replies)
  84. Solved: Need help with Click Event of OptionButton / CheckBox (3 replies)
  85. [SOLVED:] More efective sumproduct (2 replies)
  86. Solved: VBA code to copy rows from one sheet to another based on 2 criteria? (15 replies)
  87. Apply only the Font part of a Style (3 replies)
  88. Solved: find blanks= 0 (10 replies)
  89. Inserting, Renaming and Moving/Sorting Worksheets (2 replies)
  90. Solved: paste from multi sheets to 1 (3 replies)
  91. Change the Background Color of button added to worksheet using vba (2 replies)
  92. Solved: Selecting subtotal and grand total cells only(not entire row) (13 replies)
  93. Solved: Copying Formula Results (11 replies)
  94. open/activate book and edit without readonly -query (26 replies)
  95. Word frm to Excel (8 replies)
  96. Solved: Unusual Error Trap (7 replies)
  97. Macros match / Lookup (3 replies)
  98. Need help clearing (removing) buttons (2 replies)
  99. Apply macros on filtered columns (2 replies)
  100. Solved: Where to put additional code (11 replies)
  101. Loop into Excel (6 replies)
  102. Error when Export data into Excel (1 replies)
  103. Solved: Get values from cell with VBA (3 replies)
  104. Lookup Nth occurrence: cells formats (6 replies)
  105. Solved: Code Select Sheet & Range single step (2 replies)
  106. Help with macro to copy and paste based on formula result (5 replies)
  107. Insert Photo in Cell, using Userform (3 replies)
  108. Solved: Command Button Naming (3 replies)
  109. Solved: calculation (2 replies)
  110. [SOLVED:] Opening another file with title equal to a cell entry (2 replies)
  111. Solved: Loop through sheets (6 replies)
  112. Solved: Moving data to a Word document (22 replies)
  113. Transferring data from an array to a range - strange error (8 replies)
  114. Solved: Updating an access record from an excel userform (excel '97) (24 replies)
  115. top 5 and top 10 (4 replies)
  116. Solved: disable calculation (2 replies)
  117. Solved: Shifting rows to the right. (1 replies)
  118. Trouble Looping to eliminate multiple data (5 replies)
  119. Solved: Validating entry on a userform (Excel '97) (6 replies)
  120. Replace fonction vba (1 replies)
  121. Solved: How do I copy and insert rows (2 replies)
  122. How to find an error in my VBA !! (6 replies)
  123. counting data (4 replies)
  124. Formatting of data from text file into Excel File. (10 replies)
  125. days of the week (7 replies)
  126. code does work at home but not at work >< (1 replies)
  127. Error Checking for EOF / BOF Debug (1 replies)
  128. Solved: Show asterisk(****) in password VBA code (1 replies)
  129. Find function (7 replies)
  130. Solved: Only save with a Macro Button (2 replies)
  131. how to use vara function in vba (7 replies)
  132. Solved: Clearing Clip Art (8 replies)
  133. Solved: Naming a File (5 replies)
  134. Solved: Count Files in folder &amp; cell.value=NewFile.Name (8 replies)
  135. Solved: Error '1004' pops up randomly (3 replies)
  136. Hide / Unhide toolbars for a particular worksheet (8 replies)
  137. check for the values in the sheet 2 and count the values (11 replies)
  138. Solved: Merge Workbooks (6 replies)
  139. How to automaticlly disable a spreadsheet after a period of time (3 replies)
  140. Export Problem (2 replies)
  141. Error: 1004 (4 replies)
  142. [SOLVED:] Code added by VBA ends up on wrong sheet? (2 replies)
  143. Solved: Macro will not save (31 replies)
  144. Deleting all rows of named merged range (5 replies)
  145. Solved: Convert number to letter (16 replies)
  146. Last non-blank cell in a row or column (2 replies)
  147. Pop Messag Box required if value is different (2 replies)
  148. Updating external reference of a picture (0 replies)
  149. Hide/Uhide rows without macro (2 replies)
  150. Dynamic Group by, with Subtotal and Grandtotal (6 replies)
  151. UserForm;ListBox Select show Picture (7 replies)
  152. User Form Looping Problem (18 replies)
  153. Solved: should work but doesn't - application.inputbox problem? (3 replies)
  154. Unhide based on Calculate event (7 replies)
  155. Worksheet_Calculate() Multiple Ranges (2 replies)
  156. Create a working CommandButton in a Userformusing VBA Code (23 replies)
  157. Macro Help (11 replies)
  158. force enable macros (9 replies)
  159. Solved: DAYS360 function within VB (3 replies)
  160. Basic FTP upload problems please help, kinda urgent? (11 replies)
  161. Merging text from selected range of cell (16 replies)
  162. Solved: substitute &quot;.&quot; with &quot;&quot; and give format (21 replies)
  163. Solved: Checkbox with userform (3 replies)
  164. Solved: Problems with GetOpenFileName (4 replies)
  165. Solved: But it was working 5 minutes ago.... (8 replies)
  166. Phantom MsgBox (12 replies)
  167. Solved: Pagesetup.PaperSize (2 replies)
  168. side by side stack charts (10 replies)
  169. Sleeper: Sum rows based on column criteria (1 replies)
  170. Solved: Excel ShapeRange.Align (1 replies)
  171. Open all files in a directory and merge to one file (10 replies)
  172. CASE Statement type mismatch (2 replies)
  173. Passing a value to another sub routine (4 replies)
  174. VBA can not use Mshflexgrid.ocx SP6 (1 replies)
  175. Next With out for error (4 replies)
  176. Get a value from a cell (3 replies)
  177. Values used for multiple button clicks (3 replies)
  178. Solved: copying comments (9 replies)
  179. Solved: Finding local maximums in same cells on many sheets (21 replies)
  180. Conditional colouring (6 replies)
  181. userform toolbox (11 replies)
  182. row selection (18 replies)
  183. SUMIF or Vlookup - How to use in with Range Offset (5 replies)
  184. Solved: UserForm;ComboBox;FilterData (5 replies)
  185. Solved: Help Matching String Patterns (5 replies)
  186. Solved: default macro (9 replies)
  187. Solved: Compare Cells within same row for whole sheet (11 replies)
  188. Addin References (2 replies)
  189. value for a specific zip code (4 replies)
  190. Solved: Linestyle constant values (3 replies)
  191. excel failed to access some objects. (8 replies)
  192. macros on web (1 replies)
  193. [SLEEPER:] The code works, but the address is "WEIRD" (6 replies)
  194. Select Case with multiple dependencies (2 replies)
  195. Solved: Unwanted Events firing (3 replies)
  196. Qty and Time based lookup (2 replies)
  197. Fit Table content (1 replies)
  198. Solved: Selecting last row of an active column using a single macro (4 replies)
  199. Solved: Date Formula (2 replies)
  200. Solved: Excel generate calendar appointments in Outlook. (26 replies)
  201. Speeding Up HTML Table Import (2 replies)
  202. highlighting minimum and maximum values (6 replies)
  203. Solved: Reversing the order of rows??? (1 replies)
  204. 'Update Values: datasheet.xls' problem (2 replies)
  205. Inserting Hyperlink Diagbox Value to Text Box (6 replies)
  206. select column by referencing column title (2 replies)
  207. Unable to register/reference DLL (3 replies)
  208. Solved: User Form question (4 replies)
  209. Solved: Help with formula please (2 replies)
  210. [SOLVED:] Shortcut assign (2 replies)
  211. Set the Workbook_SheetChange to False ?? (12 replies)
  212. Slow Save, and the File Size Kid. (4 replies)
  213. On Key events (3 replies)
  214. Restrict Cell entry to minutes and seconds only (9 replies)
  215. Automatic alphabetic scrolling in a listbox (5 replies)
  216. Inserting image to Cell from User Form (1 replies)
  217. Staff planner- Got more ideas from my employer (6 replies)
  218. Lock OLE Excel object (VB6) (4 replies)
  219. Controlling where cursor goes to next after using Enter key (2 replies)
  220. Updating graphs based on choice in drop-down menu: (2 replies)
  221. Use SQL to fill Data Valadation list box (5 replies)
  222. Solved: Active cell highlights row (16 replies)
  223. "For Each" an endless loop, any better ideas? (3 replies)
  224. Help to Fix Program in Iraq for Troops (3 replies)
  225. protecting multi shts with separate pwrds (10 replies)
  226. UserForm:ComboBox1 select show and change data ListBox and ComboBox2 (6 replies)
  227. Solved: Emergency...gross margin algorithm! (9 replies)
  228. Skip Confirmation Prompt while saving Excel file as htm through VBA code (1 replies)
  229. activeworkbook.name space (1 replies)
  230. loop through visible pivotfields , copy to new sheet (5 replies)
  231. Solved: Custom Function for Dups (2 replies)
  232. [SOLVED:] Blank Cells and Filling Down R[-1]C (9 replies)
  233. Using LOOKUP in VBA (4 replies)
  234. Solved: Different Functions In Same Subtotal Row (17 replies)
  235. Solved: If command (2 replies)
  236. Count occurrences in specific column (9 replies)
  237. Solved: Excel 2003 - VBA Userform help (7 replies)
  238. Challenge manipulate Pivot-table from cell ranges (12 replies)
  239. How to increase the speed (3 replies)
  240. copy contents of each Workbooks with Different data ranges from a Single Folder (3 replies)
  241. Rich Text (3 replies)
  242. Transfert fron cell with condition (2 replies)
  243. Solved: Subtotal Method of Range Class Failed (7 replies)
  244. Rename multiple files (add datestamp)? (7 replies)
  245. MsgBox and Input Box Macro (6 replies)
  246. Vlookup result into a textbox - Help!! (3 replies)
  247. objIE.Document.all("btnEmailConfirmation").Click , 1 (2 replies)
  248. Combining IF criteria in DO LOOP (3 replies)
  249. Solved: VBA VLookup Help (Excel '97) (16 replies)
  250. sh.Name (4 replies)