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: Duplicate Sheets with VBA - Error cannot complet task (7 replies)
  2. query results to a specific cell (8 replies)
  3. Starting Another "Instance" of Excel (2 replies)
  4. Not Enough System Resources ... etc (9 replies)
  5. Solved: Copying coded worksheets (5 replies)
  6. play a sound in excel (8 replies)
  7. Solved: Problem with error handling with GoTo Statement (7 replies)
  8. Solved: how to pass arrays as procedure parameters? (9 replies)
  9. Solved: VBA - How to re-run a macro? (7 replies)
  10. print preview (4 replies)
  11. Freeform Nodes (6 replies)
  12. Solved: search workbook (3 replies)
  13. Help with autofilter (5 replies)
  14. Automating pivot or static charts - bigger picture (6 replies)
  15. Solved: How to import text file & extract specified strings (4 replies)
  16. Sending emails to multiple recipients (1 replies)
  17. Solved: How do I code this (10 replies)
  18. Solved: moving data from sheet1 to sheet2 (6 replies)
  19. Downloading file from internet (3 replies)
  20. Solved: ChkFolderExists not quite working (5 replies)
  21. Function returning null value instead of string value (5 replies)
  22. Solved: Matrix type vlookup (9 replies)
  23. Solved: Code Error - Extra Column Created? (20 replies)
  24. Long Code Help (0 replies)
  25. Finding "Today" (4 replies)
  26. Date range issues (11 replies)
  27. Solved: Terminology Stuff (7 replies)
  28. Solved: Userform checkbox's (2 replies)
  29. Solved: Dynamic Combobox in a userform (8 replies)
  30. Solved: Almost-Langford numbers (9 replies)
  31. Solved: Display Protection Status (7 replies)
  32. Problem With Stepping Thru VBA Code (5 replies)
  33. Solved: Implement formula as value in event code (11 replies)
  34. If it finds "Customer" then run code if it dosen't skip code (5 replies)
  35. Solved: Saves workbook as todays date? (12 replies)
  36. Solved: How to stop date updating? (4 replies)
  37. read data and put in array (1 replies)
  38. Solved: Excel CommandBars in created session (7 replies)
  39. Solved: Problem with date command button in Sign in workbook (11 replies)
  40. Solved: Highlighting Selected Cell (2 replies)
  41. Solved: MINIMIZE Button of an Excel 'FORM' (2 replies)
  42. Solved: Help needed with sign in register (6 replies)
  43. problem with date format (8 replies)
  44. MsgBox and find Info (1 replies)
  45. Solved: Msgbox formatting the text (15 replies)
  46. adding a progress bar (15 replies)
  47. If not in database then add to database (4 replies)
  48. adding rows (2 replies)
  49. Yet another sorting task. (8 replies)
  50. Specify a save folder (4 replies)
  51. Solved: Find (5 replies)
  52. Solved: Unprotect/Protect when updating/refreshing data (14 replies)
  53. Solved: Pivot Table (0 replies)
  54. Solved: Change range in code (6 replies)
  55. Open workbook if not open (7 replies)
  56. Need help speeding up code part deux (6 replies)
  57. Solved: Capitalising? (4 replies)
  58. [SOLVED:] Delete or ClearContents (16 replies)
  59. Solved: ODBC values into an array destination (9 replies)
  60. Solved: Summarise Duplicate Help (28 replies)
  61. Count number of times each injury occurs in the current month (6 replies)
  62. Refresh PivotChart excel freezes (1 replies)
  63. Error while populating a combobox from Access database (3 replies)
  64. Neep help speeding up some code (4 replies)
  65. Solved: Find Value in Column (17 replies)
  66. Solved: At each change find lowest two and copy (11 replies)
  67. FilterData & Copy (10 replies)
  68. Solved: Code example required please? (17 replies)
  69. Solved: Multiple selections (15 replies)
  70. Solved: Insert wb2 filename into wb1 cell (2 replies)
  71. Solved: Posting w/ HTML? (4 replies)
  72. Solved: Find value in column (11 replies)
  73. Copying 2nd Worksheet Below Existing Data (8 replies)
  74. Solved: Border Trouble! (2 replies)
  75. Solved: Help adding a couple lines of code (7 replies)
  76. Solved: xlPasteSpecial method (9 replies)
  77. Solved: disabling insert / delete command in excel (6 replies)
  78. Solved: Integral cells as header (3 replies)
  79. Solved: dynamic name Rage? (or better solution) (21 replies)
  80. Solved: Data won't copy to database (19 replies)
  81. Graphic problem when I print an excel file into PDF (9 replies)
  82. Solved: Assistance Reducing to Better Code (4 replies)
  83. Solved: Problem of accessibility within a project (22 replies)
  84. Unhide Rows (5 replies)
  85. Solved: Opening workbooks within subfolders (21 replies)
  86. how to copy and paste a row of cells from one worksheets to another worksheets? (2 replies)
  87. Shared Spreadsheet (1 replies)
  88. Doing a date out(radio button)twice where i want the 2nd time not allowed to (2 replies)
  89. Solved: How do you Redim Preserve a 2 dimensional array? (5 replies)
  90. Sumproduct syntax as a VBA Worksheet Function (1 replies)
  91. Fun - Ask user if they want to edit (on a timer) before running workbook_open (5 replies)
  92. Solved: help with this VBA (6 replies)
  93. Frustrated trying to Reorganize Dataset (1 replies)
  94. Solved: Looping Creation of Pivot Table (3 replies)
  95. Lost links to shortcuts (4 replies)
  96. Auto open procedure via vbscript (3 replies)
  97. Solved: UserStatus,GetObject and Application UserName (6 replies)
  98. Calculate future date w/ out weekends and holidays (10 replies)
  99. gmt function (2 replies)
  100. Solved: Worksheet naming based on cell data (3 replies)
  101. Solved: Adding Rows in Userform (10 replies)
  102. internal order of sheets, CodeName (10 replies)
  103. [SOLVED:] Sending email to Outlook with ClickYes (14 replies)
  104. Solved: Numbering by date (19 replies)
  105. Solved: Trimming Things Down... (3 replies)
  106. Switch to second worksheet or add new one (2 replies)
  107. Get Row Count after Filters have been Set (1 replies)
  108. Advice on Good Programming Books (12 replies)
  109. Sort A to G and S columns (13 replies)
  110. Solved: Problem Deleting Rows (2 replies)
  111. [SOLVED:] Auto - Filter (check on/off Status) (10 replies)
  112. How do I use createsummary? (1 replies)
  113. Friday discussion - Monty Hall (6 replies)
  114. Convert Macro to VBA (2 replies)
  115. Can we write both in left and right alignment in same cell? (5 replies)
  116. How to determine #/type of function arguments via CODE (3 replies)
  117. Can you reference an enum value as a string (7 replies)
  118. Solved: consolidating columns (7 replies)
  119. create a sequal (1 replies)
  120. Looping (6 replies)
  121. Solved: Hiding and showing a chart with a cmd btn (5 replies)
  122. How to format fonts in VBA? (3 replies)
  123. Solved: Merge Rows Problem (3 replies)
  124. 2 Files (1 replies)
  125. Concantenate Loop (3 replies)
  126. Solved: Help w/auto "Save As" macro (10 replies)
  127. Copying & pasting with a For...Next Loop (43 replies)
  128. Change the position and size of the Pie Chart (3 replies)
  129. Solved: How to Access Objects/Tools (ie ListBoxes) of a UserForm? (3 replies)
  130. Solved: Excel to Word mailmerge problem (7 replies)
  131. Macro - please help with VB Code (5 replies)
  132. Solved: check entire cell for a word (7 replies)
  133. Sum If/ Data output problems (6 replies)
  134. Move chart from one sheet to a specific location on another sheet (1 replies)
  135. Solved: Find last used cell, then insert new row & paste data from other worksheet (16 replies)
  136. Solved: Compare text strings in macro with strings in WS (11 replies)
  137. help ps, run out time (2 replies)
  138. Solved: help,about use 2 vba at the same time (4 replies)
  139. Solved: Excel Templates (3 replies)
  140. Solved: After a macro or code is run the undo function doesn't work. (3 replies)
  141. Solved: Help With Hiding Colums (4 replies)
  142. Solved: When cell is selected need to change color/highlight the row and columns (11 replies)
  143. Solved: Log Excel Worksheet Activities (3 replies)
  144. why i dont get 100% correct results (5 replies)
  145. Solved: Sum If funtion help (11 replies)
  146. Personal workbook? (3 replies)
  147. Change cell colour and copy cell format over to word (1 replies)
  148. limited times or dates usage (6 replies)
  149. ABOUT SAVE (7 replies)
  150. Solved: Autofilter's Strengths And Weaknesses.. (1 replies)
  151. Alter The Name When Saving (2 replies)
  152. Solved: Filtering out cell contents (2 replies)
  153. Solved: How do I get the VBA Extensibility library? (3 replies)
  154. Solved: How do you name an imported module via code? (4 replies)
  155. Solved: Delete rows by dates (7 replies)
  156. Solved: Design Advice & VBA Usage (5 replies)
  157. Solved: Converting Excel Sheet into PDF (19 replies)
  158. Copying specific records from specific date period (3 replies)
  159. Solved: How do I do preformatting in excel and copy that formatting + data over to word? (7 replies)
  160. RefEdit (3 replies)
  161. Solved: Create a new word doc for every worksheet? (13 replies)
  162. Solved: ActivePrinter (5 replies)
  163. How to change the target of the hyperlinks in excel VBA ?? (5 replies)
  164. Solved: Find Method - Why & How? (2 replies)
  165. Automatic Add/Delete Rows or Columns (10 replies)
  166. Find Method and WholeWord in Excel (3 replies)
  167. Excel Version problem?? (3 replies)
  168. Calculating Duration (4 replies)
  169. Solved: Can't see Reference as object (5 replies)
  170. Solved: Check whether row is odd or even (2 replies)
  171. Copy worksheet information to Word using VBA in Microsoft Excel (1 replies)
  172. Determine which strings are new and copy them to WS (1 replies)
  173. Solved: Count Text (7 replies)
  174. Controlling Defined Name Scope (6 replies)
  175. getObject disable update links or choose don't update (10 replies)
  176. Worksheet name as a variable (5 replies)
  177. macro from one workbook updates another (6 replies)
  178. Solved: Class With Events (3 replies)
  179. Solved: Deleting worksheets (3 replies)
  180. Macro to Edit Workbook Links (4 replies)
  181. Copy content from excel to word. (1 replies)
  182. Solved: Summing variable ranges (7 replies)
  183. Conditional Formatting cells containing certain (amongst other) values (5 replies)
  184. Moving Items Between ListBoxes (4 replies)
  185. Solved: Indirect Vlookup vba (6 replies)
  186. Solved: subtract time (9 replies)
  187. Find the last item and select it (4 replies)
  188. Solved: Active Workbook (14 replies)
  189. fifa 2006 (9 replies)
  190. Solved: Excel to get Data from an Access Database (16 replies)
  191. deletea ll sheets (1 replies)
  192. Solved: Sum rows according to column condition (5 replies)
  193. Importing libraries explicitly in macro code (1 replies)
  194. Solved: Help with a Loop in a Loop (2 replies)
  195. Using a cell reference/column value to copy rows to a new worksheet (4 replies)
  196. Solved: Making Excel invisible on opening (12 replies)
  197. Solved: If text then perform this, if not then skip. (3 replies)
  198. Solved: How to hide the Excel Icon in a custom menu bar (15 replies)
  199. Solved: Setting a date range (5 replies)
  200. Delete duplicates (2 replies)
  201. textbox autotab and maxlength properties (1 replies)
  202. Template-document new equivilant in Excel (3 replies)
  203. Solved: Convert formula to vba code (4 replies)
  204. Solved: Removing hyperlinks (6 replies)
  205. calling the internet (1 replies)
  206. pick up same artno but differnet attribute (1 replies)
  207. Getting list of table & field names from Access into Excel using VBA (1 replies)
  208. Solved: retrieve specified field data from other Excel file & append to current Excel file. (3 replies)
  209. WordWrap and TextBoxes (2 replies)
  210. Count Rows (30 replies)
  211. If this do that, If not Do the other (3 replies)
  212. Solved: Code is broken (3 replies)
  213. Switch to unknown named workbook (9 replies)
  214. Macro to Delete IF (17 replies)
  215. Solved: how to display all options of a combo box (3 replies)
  216. [SOLVED:] Reading Tag name, editing it and saving. (3 replies)
  217. Solved: Disable "X" Button on ActiveWorkBook (8 replies)
  218. moving row of data from one sheet to another (3 replies)
  219. Copy worksheet information to Word using VBA in Microsoft Excel (3 replies)
  220. Scope of Two Defined Identical Names (2 replies)
  221. Password Protection (4 replies)
  222. Can you ppl help me test this macro? (3 replies)
  223. Solved: how to buttom changed from inactive to active (2 replies)
  224. Streamline code from MRecorder to Good Code Help (3 replies)
  225. Solved: Help understanding line of code (3 replies)
  226. Solved: How to Paste.Special.Values w/ this line of code (17 replies)
  227. multiselect list box (17 replies)
  228. Help on code found here (InputBox Type 8) (2 replies)
  229. Solved: Help: Adding function to line of code (9 replies)
  230. Inserting Values in a Multidimensional Array from Two Different Controls (6 replies)
  231. Solved: Excel macro question: matching text to numeral value & inserting the numerals + more! (4 replies)
  232. Solved: Finding a range based off of two comboboxes (1 replies)
  233. Format a cell before writing in it (2 replies)
  234. Solved: Problem with indexing on a user form (0 replies)
  235. Solved: Select Rows by Date (22 replies)
  236. Match & Index Functions (2 replies)
  237. Solved: select other object when a textbox is full (4 replies)
  238. Populate empty cells with zeroes? (3 replies)
  239. Solved: Can't use Right function??? (3 replies)
  240. Solved: do - until cell equals blank (5 replies)
  241. Solved: Copy specific rows (3 replies)
  242. Solved: MDI "like" child userforms ? (9 replies)
  243. summing months (5 replies)
  244. Where Are the Hidden AutoShapes?? (12 replies)
  245. Solved: For Each c In Range("Test") (13 replies)
  246. dates between dates??? (10 replies)
  247. put range of cells into variable (11 replies)
  248. Solved: Rewrite this line of code (6 replies)
  249. Merging cells and suppress excel's popup (4 replies)
  250. Solved: Sort Non-Adjacent Columns (3 replies)