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. Unhide based on Calculate event (7 replies)
  2. Worksheet_Calculate() Multiple Ranges (2 replies)
  3. Create a working CommandButton in a Userformusing VBA Code (23 replies)
  4. Macro Help (11 replies)
  5. force enable macros (9 replies)
  6. Solved: DAYS360 function within VB (3 replies)
  7. Basic FTP upload problems please help, kinda urgent? (11 replies)
  8. Merging text from selected range of cell (16 replies)
  9. Solved: substitute "." with "" and give format (21 replies)
  10. Solved: Checkbox with userform (3 replies)
  11. Solved: Problems with GetOpenFileName (4 replies)
  12. Solved: But it was working 5 minutes ago.... (8 replies)
  13. Phantom MsgBox (12 replies)
  14. Solved: Pagesetup.PaperSize (2 replies)
  15. side by side stack charts (10 replies)
  16. Sleeper: Sum rows based on column criteria (1 replies)
  17. Solved: Excel ShapeRange.Align (1 replies)
  18. Open all files in a directory and merge to one file (10 replies)
  19. CASE Statement type mismatch (2 replies)
  20. Passing a value to another sub routine (4 replies)
  21. VBA can not use Mshflexgrid.ocx SP6 (1 replies)
  22. Next With out for error (4 replies)
  23. Get a value from a cell (3 replies)
  24. Values used for multiple button clicks (3 replies)
  25. Solved: copying comments (9 replies)
  26. Solved: Finding local maximums in same cells on many sheets (21 replies)
  27. Conditional colouring (6 replies)
  28. userform toolbox (11 replies)
  29. row selection (18 replies)
  30. SUMIF or Vlookup - How to use in with Range Offset (5 replies)
  31. [SOLVED:] UserForm;ComboBox;FilterData (5 replies)
  32. Solved: Help Matching String Patterns (5 replies)
  33. Solved: default macro (9 replies)
  34. [SOLVED:] Compare Cells within same row for whole sheet (11 replies)
  35. Addin References (2 replies)
  36. value for a specific zip code (4 replies)
  37. Solved: Linestyle constant values (3 replies)
  38. excel failed to access some objects. (8 replies)
  39. macros on web (1 replies)
  40. [SLEEPER:] The code works, but the address is "WEIRD" (6 replies)
  41. [SOLVED:] Select Case with multiple dependencies (2 replies)
  42. Solved: Unwanted Events firing (3 replies)
  43. Qty and Time based lookup (2 replies)
  44. Fit Table content (1 replies)
  45. Solved: Selecting last row of an active column using a single macro (4 replies)
  46. Solved: Date Formula (2 replies)
  47. [SOLVED:] Excel generate calendar appointments in Outlook. (26 replies)
  48. Speeding Up HTML Table Import (2 replies)
  49. highlighting minimum and maximum values (6 replies)
  50. Solved: Reversing the order of rows??? (1 replies)
  51. 'Update Values: datasheet.xls' problem (2 replies)
  52. Inserting Hyperlink Diagbox Value to Text Box (6 replies)
  53. select column by referencing column title (2 replies)
  54. Unable to register/reference DLL (3 replies)
  55. Solved: User Form question (4 replies)
  56. Solved: Help with formula please (2 replies)
  57. [SOLVED:] Shortcut assign (2 replies)
  58. Set the Workbook_SheetChange to False ?? (12 replies)
  59. Slow Save, and the File Size Kid. (4 replies)
  60. On Key events (3 replies)
  61. Restrict Cell entry to minutes and seconds only (9 replies)
  62. Automatic alphabetic scrolling in a listbox (5 replies)
  63. Inserting image to Cell from User Form (1 replies)
  64. Staff planner- Got more ideas from my employer (6 replies)
  65. Lock OLE Excel object (VB6) (4 replies)
  66. Controlling where cursor goes to next after using Enter key (2 replies)
  67. Updating graphs based on choice in drop-down menu: (2 replies)
  68. Use SQL to fill Data Valadation list box (5 replies)
  69. Solved: Active cell highlights row (16 replies)
  70. "For Each" an endless loop, any better ideas? (3 replies)
  71. Help to Fix Program in Iraq for Troops (3 replies)
  72. protecting multi shts with separate pwrds (10 replies)
  73. UserForm:ComboBox1 select show and change data ListBox and ComboBox2 (6 replies)
  74. Solved: Emergency...gross margin algorithm! (9 replies)
  75. Skip Confirmation Prompt while saving Excel file as htm through VBA code (1 replies)
  76. activeworkbook.name space (1 replies)
  77. loop through visible pivotfields , copy to new sheet (5 replies)
  78. Solved: Custom Function for Dups (2 replies)
  79. [SOLVED:] Blank Cells and Filling Down R[-1]C (9 replies)
  80. Using LOOKUP in VBA (4 replies)
  81. Solved: Different Functions In Same Subtotal Row (17 replies)
  82. Solved: If command (2 replies)
  83. Count occurrences in specific column (9 replies)
  84. Solved: Excel 2003 - VBA Userform help (7 replies)
  85. Challenge manipulate Pivot-table from cell ranges (12 replies)
  86. How to increase the speed (3 replies)
  87. copy contents of each Workbooks with Different data ranges from a Single Folder (3 replies)
  88. Rich Text (3 replies)
  89. Transfert fron cell with condition (2 replies)
  90. Solved: Subtotal Method of Range Class Failed (7 replies)
  91. Rename multiple files (add datestamp)? (7 replies)
  92. MsgBox and Input Box Macro (6 replies)
  93. Vlookup result into a textbox - Help!! (3 replies)
  94. objIE.Document.all("btnEmailConfirmation").Click , 1 (2 replies)
  95. Combining IF criteria in DO LOOP (3 replies)
  96. Solved: VBA VLookup Help (Excel '97) (16 replies)
  97. sh.Name (4 replies)
  98. sheet and workbook called "ii????.tmp" (8 replies)
  99. Sleeper: Timeout (3 replies)
  100. Solved: too many buttons (2 replies)
  101. Using VBA to sort data (1 replies)
  102. Command Button to extract data from UserForm (7 replies)
  103. Put code WS modules not a General module?? (5 replies)
  104. Solved: VBA Sort using the Left 7 Charaters (3 replies)
  105. Variable Filename in Macro to SaveAs (3 replies)
  106. Solved: charts (2 replies)
  107. Arrays, searches, and replacement (4 replies)
  108. combobox in an addin (1 replies)
  109. i have a problem with my user defined class (3 replies)
  110. Solved: working with Dates (3 replies)
  111. Adding and removing Excel menu buttons (2 replies)
  112. Solved: Startup template not used after 2007 Install (2 replies)
  113. Pivot Table Drilldown (2 replies)
  114. Solved: IF...Then...Else (5 replies)
  115. looking up text and cell fomat? (1 replies)
  116. Vlookup or Match? Copying data from one sheet to another. (5 replies)
  117. Customising Comments (3 replies)
  118. Keeping data the way it should be... (23 replies)
  119. Solved: Indirect using row numbers. (2 replies)
  120. [SOLVED:] How to hide the sub popup menu (13 replies)
  121. 1000 row filter (5 replies)
  122. userform (7 replies)
  123. Error when file to save is already opened. (3 replies)
  124. Select a record from a combobox and add data to to the selected record row. (5 replies)
  125. Solved: Finish Data update before rest of macro runs (6 replies)
  126. Paste Screenhots (2 replies)
  127. Please help - writing simple formula in VBA (3 replies)
  128. Align shapes within cells and fix their position (1 replies)
  129. Solved: Summary using VBA (3 replies)
  130. Solved: Help with For Each...Next please (3 replies)
  131. cell within range reference (4 replies)
  132. [SLEEPER:] Very Beginner Question Excel 2003 or 2007 (21 replies)
  133. UserForm ComboBox (4 replies)
  134. UserForm within procedure - help (1 replies)
  135. Worksheet macro (10 replies)
  136. Solved: UserForm Entry Cell to Change Colour (2 replies)
  137. Multipage Control in UserForm (4 replies)
  138. Solved: Format Cell Question (1 replies)
  139. [SOLVED:] VLOOKUP Problem formula not vba (10 replies)
  140. Count rows which meet three conditions ??? (7 replies)
  141. [SLEEPER:] PDF Printing (0 replies)
  142. Error 2147417848 (80010108) (3 replies)
  143. SOLVED: simultaneous searching (26 replies)
  144. Substitute Macro using a lookup column (7 replies)
  145. Convert Cols into Rows (9 replies)
  146. refedit range comparison (7 replies)
  147. Solved: create multiple folders from worksheet (4 replies)
  148. New Instance of InternetExplorer (1 replies)
  149. Solved: If formula result is Zero then Blank (3 replies)
  150. Copy and paste after looping (7 replies)
  151. Simple date validation (7 replies)
  152. Solved: Macro Help (20 replies)
  153. Button Extraordinaire (0 replies)
  154. Using a Range name as part of a function (7 replies)
  155. Big IF Loop Question (8 replies)
  156. Solved: Saving single page from multiple workbook (4 replies)
  157. conditional formatting by text colour (8 replies)
  158. personal.xls (9 replies)
  159. Solved: Group Data to another Cell (5 replies)
  160. Copying from one sheet to another and choose samples (10 replies)
  161. Solved: How do I run a macro in a form module from a class module (23 replies)
  162. Solved: Why does this not add borders to the textbox added on the active chart? (7 replies)
  163. Copying data from a series of Excel files. (8 replies)
  164. sound with vba (6 replies)
  165. Copy Code from Module2 to Module1 (8 replies)
  166. Using refedit in named range (6 replies)
  167. Solved: 12 month Update Code (21 replies)
  168. Solved: Use named range with combobox (3 replies)
  169. Solved: Error Handling Question (3 replies)
  170. Solved: Faster way to Trim() ??? (18 replies)
  171. Solved: rand numbers (3 replies)
  172. Delete formulas when unprotect (7 replies)
  173. Trying to write to embedded OLE Excel sheet in VB6 (1 replies)
  174. Solved: Copy/Paste cells into new sheet based on value list in 3rd sheet (4 replies)
  175. Adding checkboxes to forms at runtime (2 replies)
  176. Conditional Formatting (11 replies)
  177. Solved: R1C1 AND Letters - is there a way to see both (2 replies)
  178. word to Excel or Access (1 replies)
  179. Copy filtered data in new sheet and name it after criteria (2 replies)
  180. Solved: Colour cell based on range value (2 replies)
  181. Solved: uCase, cut and paste (2 replies)
  182. Solved: Formatting of a cell (6 replies)
  183. Solved: How to add textbox to a chart on a worksheet? (2 replies)
  184. Solved: Why does this code increase the height of chart when copied as picture? (2 replies)
  185. Automatically updating into next cell below (4 replies)
  186. calculating std deviation with blank cells (5 replies)
  187. [SOLVED:] Running specific line of macro (8 replies)
  188. Solved: = <> vba case sensitive (6 replies)
  189. [SLEEPER:] Importing External Data with new DB query (1 replies)
  190. help with listbox columns... (5 replies)
  191. Where's the Bug (6 replies)
  192. average letter grades forumula (6 replies)
  193. Solved: UserForm Checkboxes (4 replies)
  194. Solved: wkb.close (5 replies)
  195. Date Format Issue from Input Box (4 replies)
  196. OLAP cubes and Pivot Tables (0 replies)
  197. Merging 2 identical tables - Access 03 (2 replies)
  198. Solved: Date not updated from the calendar popup (2 replies)
  199. [SOLVED:] With named range conditional format (2 replies)
  200. Solved: Ungrouping Columns if the exsist (2 replies)
  201. Run macro on cell text change (4 replies)
  202. Solved: How to find/calculate height & width of chart title in Excel VBA? (5 replies)
  203. Solved: Unique Defined Named Range and Validation List (12 replies)
  204. Exploring Userform Capabilities (4 replies)
  205. Solved: Run a program from VBA, and capture output (5 replies)
  206. SOLVED: Run macro all all open workbooks with one exception (4 replies)
  207. Copy String up to the 3rd Space (8 replies)
  208. Solved: help with excel vba... (8 replies)
  209. [SOLVED:] Solved: vlookup error 2042 (12 replies)
  210. Data Types in Cells (3 replies)
  211. Solved: MOD formula (14 replies)
  212. Solved: lookup for part of a cell (13 replies)
  213. Solved: Problem using PDFcreator 0.9.7 with Excel 2007 (10 replies)
  214. [SLEEPER:] Macro with sum formula (1 replies)
  215. Subtotal or pivot table using date fields (3 replies)
  216. copy imported data into other sheet (2 replies)
  217. deactivate macro after "save as" (2 replies)
  218. How to clear repeating attachments (8 replies)
  219. Sorting in a Protected Worksheet (0 replies)
  220. Losing datagrid and flexgrid (1 replies)
  221. Copy and Paste from worksheets within Workbook (4 replies)
  222. Solved: The Dreaded #REF! (4 replies)
  223. Solved: creating pie chart with data from Access (12 replies)
  224. Solved: Some Sort of Lookup? (5 replies)
  225. Help with a matching code (8 replies)
  226. Pass User defined Type between two open Excel workbooks (4 replies)
  227. hyperlinks in excel (1 replies)
  228. Report Generation (8 replies)
  229. Quick CountA question (2 replies)
  230. Solved: Transfer separate ranges to one range (1 replies)
  231. Solved: VBA to search then copy found data (3 replies)
  232. [SOLVED:] LOAD/UNLOAD Pictures from/to Excel <> Access database (4 replies)
  233. How to sign digital certification by script or code? (1 replies)
  234. Automate Data Entry with Excel (1 replies)
  235. open form according to active workbook (1 replies)
  236. Solved: Compare Column Data (4 replies)
  237. Excel VBA/Email help (5 replies)
  238. [SLEEPER:] Dynamically adding Calendar dates to table (4 replies)
  239. VBA to open excel file one sharepoint, copy the info and move to another work book (1 replies)
  240. republish sheets to html (0 replies)
  241. Solved: Referencing a Name Range with VBA (3 replies)
  242. Passing data from VBE to a range of cells (3 replies)
  243. Solved: Will there be VBA in Excel 2009 (3 replies)
  244. Solved: A basic script going wrong (23 replies)
  245. Error: The subject is not trusted for the... (0 replies)
  246. Solved: Populating a Listbox (ADO method Access '97 into Excel '97) (12 replies)
  247. [SOLVED:] Copy and Paste from other Workbooks with conditions (16 replies)
  248. Is it posible to use range("CR:CR").Find(value) to find a value between two numbers (4 replies)
  249. userform problem (2 replies)
  250. use code on a new workbook (1 replies)