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. Autocomplete (8 replies)
  2. Solved: Copy a workbook (4 replies)
  3. Solved: Hide worksheets file close (3 replies)
  4. Listbox Row Source (3 replies)
  5. Solved: Copying & pasting multiple columns using VBA (10 replies)
  6. How to speed up cut and paste macro code (12-16-09) (1 replies)
  7. Macros in dropdown menu in Menubar (6 replies)
  8. Solved: HELP - Multiple User Worksheet - Code Amend (2 replies)
  9. Solved: Importing Email from Outlook to Excel (9 replies)
  10. Solved: Replace Cell with Formula - automatically (7 replies)
  11. I need help cleaning up this code. (9 replies)
  12. Solved: Sum Crazy, sum columns with variable headers (7 replies)
  13. Auto Reply Notification (1 replies)
  14. Open PDF (via VBA) on specific page (0 replies)
  15. Solved: Setting CommandButton = False under a specific condition (7 replies)
  16. Solved: Equivalent Range on specific row (4 replies)
  17. Solved: Adjusting If-Then statement in code (10 replies)
  18. Solved: Matched (2 replies)
  19. Solved: Application.Max(rng) (4 replies)
  20. Solved: import from text, run VBA, all in one shot? (5 replies)
  21. Solved: Problems with finding last column (3 replies)
  22. Sorting Numbers-as-Text with Data|Sort + AutoFilters (1 replies)
  23. Solved: Transferring data (5 replies)
  24. Solved: Sum Corresponding cell from different worksheet (3 replies)
  25. Solver Error: Set Cell must be a single cell on the active sheet (2 replies)
  26. Solved: creating desktop shortcuts (2 replies)
  27. Solved: named range issue (5 replies)
  28. finding any coloured cell (3 replies)
  29. Check if Visual Basic Editor is open (10 replies)
  30. Type Mismatch (1 replies)
  31. Solved: Setting Cell Value = #N/A (5 replies)
  32. Solved: workbook referencing another workbook (7 replies)
  33. Solved: change text in multiple cells with VBA (6 replies)
  34. Solved: Extract file names & h-link, combine codes (2 replies)
  35. Solved: Find in VBA (3 replies)
  36. Dim Array() As Workbook?? (2 replies)
  37. Running a Macro in one workbook from another workbook (15 replies)
  38. Solved: Type Mismatch? (5 replies)
  39. Solved: Change Password on Multiple Files in a Folder (7 replies)
  40. Solved: Hiding sheets (8 replies)
  41. Marco for print outs (1 replies)
  42. CHART Challenge: Plot NA# as null values (6 replies)
  43. clear format problem (5 replies)
  44. data base user form question (2 replies)
  45. Dynamic chart with VBA (2 replies)
  46. Solved: Help with VBA Code (5 replies)
  47. UserForm & Macros from Office 2003 to Office 2007 causes errors. Any ideas? (1 replies)
  48. Solved: Format Date data (3 replies)
  49. [SLEEPER:] Referencing drop down menu in worksheet (2 replies)
  50. Solved: Remove characters from text function (6 replies)
  51. Solved: Change a reference in a formula as you drag the formula from cell to cell (3 replies)
  52. add 4 formula to current macro (2 replies)
  53. Solved: How do you find first Cell (5 replies)
  54. Solved: Find Out what Page a cell will print on (3 replies)
  55. Set Field Tab Order (3 replies)
  56. Preview Groupwise Draft Messages before sending (0 replies)
  57. Solved: Triangulation help needed. (8 replies)
  58. Solved: Insert name and auto save as... macro help (22 replies)
  59. Manipulate VBE Window (5 replies)
  60. Print records after filtering in mail merge from excel to word (3 replies)
  61. Edit Personal.xls via Macro (16 replies)
  62. Solved: Updating named ranges between two versions of the same file (7 replies)
  63. big problem xls file (7 replies)
  64. Window Activate Anomoly (2 replies)
  65. Solved: Function to return Date based on Current Date + number of Days? (10 replies)
  66. Holding the formatting on a table from a website (2 replies)
  67. Solved: auto descending order using macro (11 replies)
  68. Solved: Why is this line failing on me? (7 replies)
  69. add picture (3 replies)
  70. Solved: macro to copy data - down other columns (5 replies)
  71. tips and techniques on how to properly design your vba for distribution (10 replies)
  72. AutoFilter Problem (1 replies)
  73. Solved: Really Stupid Question (4 replies)
  74. Solved: AutoFill VBA is not working with my formula :S (2 replies)
  75. Solved: Create New Record in Access from Excel Macro (1 replies)
  76. Solved: Calling the Solver from VBA (6 replies)
  77. macro assistance - (15 replies)
  78. Get Formula (4 replies)
  79. Solved: Matching up columns of data (6 replies)
  80. Files getting inexplicably bigger! (2 replies)
  81. Solved: Copy range when its not zero (19 replies)
  82. Transferring data from one Userform to the next (2 replies)
  83. Losing control once I press a web page button. HELP! (1 replies)
  84. Change TextBox To ComboBox (2 replies)
  85. Selecting 1 column data from Multicolumn-Combobox (3 replies)
  86. copy a module from one workbook to another via code (13 replies)
  87. Checking for DOS executions (1 replies)
  88. Solved: copy sheet to a different workbook (6 replies)
  89. Draw line between data points on excel chart (6 replies)
  90. Utilising Range (1 replies)
  91. Passing Values::Arrays (2 replies)
  92. Solved: Text from mutliline txtbox to merged cell (5 replies)
  93. filtering (1 replies)
  94. Macro Help (8 replies)
  95. decision tree (5 replies)
  96. Pulling data from between apostrophes ? (5 replies)
  97. Solved: Insert new data in first row (6 replies)
  98. Solved: What did Mr. Gates do to me now? (1 replies)
  99. macro to edit data in worksheet (3 replies)
  100. vba and scripting (1 replies)
  101. How do I Drag and Drop to a Userform Control? (5 replies)
  102. Solved: Copy information in named range to another workbook (2 replies)
  103. Solved: Variable as AutoFilter Criteria (8 replies)
  104. delete all #n/a (4 replies)
  105. moving data to another tab in Excel (6 replies)
  106. Help with Function in 2003 conversion to 2007 (7 replies)
  107. Solved: Forms - creating a wizard with moving parts (1 replies)
  108. Solved: default program for a file type (6 replies)
  109. Solved: Counting cells in one column based on values in a different column. (4 replies)
  110. Solved: event to capture changing the height or width of a cell (2 replies)
  111. Drawing Borders in VBA (6 replies)
  112. Solved: remove/delete cells (7 replies)
  113. Solved: macro to delete rows (2 replies)
  114. [SOLVED:] creating subfolders and saving files in them (7 replies)
  115. Solved: if formula (2 replies)
  116. Insert row after data change (4 replies)
  117. Opening and saving an email attachment from outlook (0 replies)
  118. Solved: Copy Paste Loop Multiple Sheets (5 replies)
  119. 1004 / Out of memory (2 replies)
  120. Vba Code Error (10 replies)
  121. Solved: remove/delete empty rows (3 replies)
  122. Solved: formatt numbers macro (2 replies)
  123. Solved: I want to set column H to column V as the email body (15 replies)
  124. Solved: if formula (2 replies)
  125. macro to speed up deleting empty rows process (7 replies)
  126. Excel VBA code to get Autofiltered data to array (9 replies)
  127. Solved: Yield to Maturity (5 replies)
  128. Error Copying Data (3 replies)
  129. screen redraw problem (not ScreenUpdating) (2 replies)
  130. iexplorer macro (0 replies)
  131. Solved: Chart Format (2 replies)
  132. Response Time UDF needs to be modified (3 replies)
  133. Solved: Parse cell data into seperate columns (7 replies)
  134. Solved: VBA Sources (3 replies)
  135. Solved: Macro for finding rows and copying to a new sheet. (2 replies)
  136. Sorting items in a multi-column listbox (1 replies)
  137. vlookup macro tricky (1 replies)
  138. [SOLVED:] Using Ampersand "Showing a Zero" (9 replies)
  139. Solved: Userform - Code as written will not populate all 22 data elements (7 replies)
  140. Solved: macro to edit/format data in excel 2007 (6 replies)
  141. Solved: New to VBA (18 replies)
  142. Dealing with #N/A and non-continuous sums (2 replies)
  143. Multiple Column Listbox help (6 replies)
  144. open xlsm vs. xls (6 replies)
  145. adding code to a sheet that is added at runtime (2 replies)
  146. Click on cell to open item for editing (7 replies)
  147. Solved: Application-defined or object-defined error (3 replies)
  148. Getting the integer of the month (3 replies)
  149. Manipulate the Ribbon from VBA directly (3 replies)
  150. Disable or enable (2 replies)
  151. Problem Importing Files (1 replies)
  152. Error 438 FileDialog Filters.Add (5 replies)
  153. Formating Data (1 replies)
  154. Solved: Rearrange the location in txt file by EXcel VBA (1 replies)
  155. folders and subfolders troubles (4 replies)
  156. Automate Lagging of Variables (8 replies)
  157. Solved: vlookup with condition (4 replies)
  158. Solved: code to turn on update links (5 replies)
  159. excel date activated self destruct (1 replies)
  160. right click menu (2 replies)
  161. error when changing data in a Pivot table usinga macro (2 replies)
  162. Filtering data with userform (11 replies)
  163. Solved: copy range issue (15 replies)
  164. Solved: worksheet scrolling (8 replies)
  165. [SOLVED:] Excel userform ListBox multicolumn (3 replies)
  166. Paste Multiple lines into single Cell (2 replies)
  167. Sort Alphanumeric Data & Retaining Leading Zeros (2 replies)
  168. Solved: ListBox as a Variable? (6 replies)
  169. Formating Subtotals (3 replies)
  170. Syntax on Application.Average (2 replies)
  171. [SOLVED:] Why Is my code so painfully slow? (3 replies)
  172. Copying a Textbox and Combobox at runtime (4 replies)
  173. Filter in Excel (1 replies)
  174. function (1 replies)
  175. Solved: MsgBox to ensure proper values are used (4 replies)
  176. Solved: How incorporate an OR( into a MAX(IF( function? (6 replies)
  177. [SOLVED:] How to Reference Sheet Name in Formula (2 replies)
  178. HELP with Removing Styles: error029120_01.xml (0 replies)
  179. Drop List for a column... (3 replies)
  180. Hi I have a workbook with sheets named from A to Z. These sheets suport a smalboboxes (5 replies)
  181. Using 1 file to create 2. (1 replies)
  182. Auto Run Macro (4 replies)
  183. Move sheets to a password protected closed workbook (1 replies)
  184. Cannot delete SendTo or My Docs folder with DeleteFolder (3 replies)
  185. Standard open/save file forms in VBA (3 replies)
  186. Outlook Manipulation via Excel VBA (0 replies)
  187. vba validation list (2 replies)
  188. Solved: Private Sub Worksheet_Change(ByVal Target As range) (3 replies)
  189. Sleeper: Biffed something in the code... (5 replies)
  190. Solved: Using months and weeks in Lookup formulae (5 replies)
  191. suffix (1 replies)
  192. delete spaces (1 replies)
  193. Solved: Probably not the right tool but...can Excel.. (16 replies)
  194. fill column when a row criteria was satisfied (2 replies)
  195. Userform On Website? (3 replies)
  196. open a new instance of Excel (9 replies)
  197. Solved: Create folders if don't exist (2 replies)
  198. application defined error - VBA (1 replies)
  199. Comparison on 2 sheets base on a unique name (3 replies)
  200. verify text of IE (1 replies)
  201. Solved: convert number to text (6 replies)
  202. how to highlight the first value in a listbox (8 replies)
  203. Solved: Detail MsgBox (1 replies)
  204. Excel - WebBrowser Control - Vista/IE7 (4 replies)
  205. How to show Detail Box (10 replies)
  206. a word of thanks to all those that help in this forum (0 replies)
  207. [SOLVED:] VBA to convert .exe (6 replies)
  208. Listbox with zero entries (9 replies)
  209. Solved: recursive sheet deactivate event (10 replies)
  210. Script out of range error (7 replies)
  211. manipulating Excel's "Normal" style (11 replies)
  212. Solved: Find records and return values to new column (5 replies)
  213. Solved: Dynamic Drop down list based on filtered list (2 replies)
  214. Having problems trapping error 76 (6 replies)
  215. Open File for Output:: What if file does not exist? (2 replies)
  216. Solved: VBA coding help (5 replies)
  217. Solved: Forms with hyperlinks (3 replies)
  218. Wanted: Testing and feedback of Duplicate Master addin V2.0 (14 replies)
  219. Click listbox and Show picture (3 replies)
  220. Help with For Loop Structure (3 replies)
  221. Solved: VB control of IE Dialog box (7 replies)
  222. Solved: Find last row and set range name programmatically (2 replies)
  223. Solved: Repeating Rows at the BOTTOM (7 replies)
  224. Solved: Creating a look-up and complete macro (12 replies)
  225. Change sheet to PDF & Delete Sheet (3 replies)
  226. Solved: excel vba book recommendations (2 replies)
  227. Solved: can you get vba to declare variables based on an argument passed (1 replies)
  228. Do Update only Loop, NOT again from start Sub with DDE link (2 replies)
  229. How to update a list to fill combobox (14 replies)
  230. Solved: How to check if user has PI tag addin if not add it? (2 replies)
  231. Solved: need help for ranking a list (2 replies)
  232. Update excel record to existing DBtable (4 replies)
  233. Extract string within tags (1 replies)
  234. Checking each cell in a row (8 replies)
  235. Placing data on a closed excel file in Sharepoint (1 replies)
  236. [Urgent] Getting NetWare Info for Owner of File into Excel 2003 via VBA? (3 replies)
  237. Copy & Pasting in VBA (3 replies)
  238. Solved: Macro won't run (5 replies)
  239. Loop OK manually, but "freezes", when run with DDE update (1 replies)
  240. Trouble with pasting a formula (3 replies)
  241. Delete Macro (7 replies)
  242. Solved: Percentrank :CSE (6 replies)
  243. Copy Paste of Filtered data with hidden columns (2 replies)
  244. Switch off subtotal on pivot table (2 replies)
  245. record and play macro to create commandbutton gives different results (10 replies)
  246. Referencing worksheet name using code name (7 replies)
  247. Solved: Instr & bold (2 replies)
  248. Hyperlink to Search Folder for a Number (20 replies)
  249. Solved: Error::Can'tDeclare Array as 'Public' ::What is Excel's Problem now? (4 replies)
  250. Not able to access input boxes on a web page (3 replies)