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. [SOLVED:] Excel Userform List box question (2 replies)
  2. [SOLVED:] Saving as .csv with parmaeters (5 replies)
  3. [SOLVED:] HLookup without sorted data? (1 replies)
  4. [SOLVED:] Delete Range With Condition (6 replies)
  5. [SOLVED:] Sleeper: Control Range Scanned (1 replies)
  6. [SOLVED:] Tabbing in a user form (4 replies)
  7. [SOLVED:] Simple question about strings? (7 replies)
  8. [SLEEPER:] Linking a Hyperlink (info inside) (4 replies)
  9. [SOLVED:] Delete sheet without prompting (2 replies)
  10. Sleeper: Merge dynamic array list (6 replies)
  11. [SOLVED:] Is the name found in both lists? (3 replies)
  12. [SOLVED:] Add New Sheet and Copy over data (5 replies)
  13. [SOLVED:] Mass Change Of Cond'l Fmting Variable Names (3 replies)
  14. [SOLVED:] Unique values (2 replies)
  15. [SOLVED:] Properties of Named Rectangles (5 replies)
  16. [SLEEPER:] Question about links (1 replies)
  17. Sleeper: Shift Columns Down (3 replies)
  18. [SOLVED:] Move Macro buttons to a new sheet then sort (2 replies)
  19. [SOLVED:] Extract data from one workbook and copy and paste it to another (6 replies)
  20. [SOLVED:] Automatic re-sorting of data (7 replies)
  21. [SOLVED:] Inserting new slide in PP from Excel (3 replies)
  22. [SOLVED:] Gotta be a better way (6 replies)
  23. [SOLVED:] Sumif a weekly total (3 replies)
  24. Solved: Procedure "Sheet_Activate_1()" Does What? (9 replies)
  25. [SOLVED:] Help - A question from Ella. (3 replies)
  26. [SOLVED:] Insert row based on string (5 replies)
  27. [SOLVED:] Estimate End Result (9 replies)
  28. [SOLVED:] What is the code for the current date? (11 replies)
  29. [SOLVED:] Protecting an excel file (3 replies)
  30. [SOLVED:] Print Preview (4 replies)
  31. Sleeper: Problematic queries (2 replies)
  32. Sleeper: Remove duplications (8 replies)
  33. [SOLVED:] If I want to change the contents in the cell (9 replies)
  34. Sleeper: Click Button to select Button's Cell (4 replies)
  35. [SOLVED:] How Do You Make the "Beep" API Work? (4 replies)
  36. [SOLVED:] Color cell dependant on other cell value (4 replies)
  37. Sleeper: SQL and Excel (1 replies)
  38. [SOLVED:] Print report from Listbox (10 replies)
  39. Sleeper: Running Multiple Macros from a command button (3 replies)
  40. Sleeper: Using part cell to lookup refs (11 replies)
  41. [SOLVED:] Check mysheet is active (4 replies)
  42. [SOLVED:] Norton alert with vbs (3 replies)
  43. [SOLVED:] Converting a database from Excel to Access (4 replies)
  44. Sleeper: Charting Hell (4 replies)
  45. Sleeper: Array formula (18 replies)
  46. [SOLVED:] Run a macro from info on another sheet (2 replies)
  47. [SOLVED:] Examining the Formula in a Cell (3 replies)
  48. [SOLVED:] Solved: Tell Me About VB Script (5 replies)
  49. Sleeper: Any way to fix the scale ( inches / mm / cm ) of chart or excel sheet ? (2 replies)
  50. [SOLVED:] Updating blank only cells (4 replies)
  51. [SOLVED:] Remove duplications (3 replies)
  52. [SOLVED:] Assigning a macro a shortcut from the desktop (1 replies)
  53. [SOLVED:] Invert numbers (2 replies)
  54. [SOLVED:] How to create a drop down list. (19 replies)
  55. [SOLVED:] Break at First Number in String (11 replies)
  56. [SOLVED:] Can This Expression Be Simplified? (5 replies)
  57. [SOLVED:] What's Wrong With This "WhatIf"? (2 replies)
  58. [SOLVED:] Search list with Vlookup (7 replies)
  59. [SOLVED:] Follow up on code provided by C. Paleo (20 replies)
  60. [SOLVED:] Copying a range of cells of active worksheet to a new workbook (3 replies)
  61. Sleeper: Update list from a ranges input (19 replies)
  62. [SOLVED:] Error: AutoFilter method of Range Class failed (27 replies)
  63. [SOLVED:] How do I put insert Linebreak (2 replies)
  64. [SOLVED:] Error I recieved!! (2 replies)
  65. Solved: Force string array to return text, not numbers? (2 replies)
  66. Sleeper: Poker discussion / odds (9 replies)
  67. [SOLVED:] What is equivalent to "or" in VBA? (17 replies)
  68. [SOLVED:] Easy question (3 replies)
  69. [SOLVED:] Rank (4 replies)
  70. [SOLVED:] get latest? (3 replies)
  71. [SOLVED:] Run/Test Code Without Printing (13 replies)
  72. [SOLVED:] Need help to create macro (4 replies)
  73. [SOLVED:] I tried to run a macro and it gave this error (3 replies)
  74. [SOLVED:] Need help to shorten The DeleteEdsMenuItems (4 replies)
  75. [SOLVED:] Need help with hiding row under the following circumstances (21 replies)
  76. [SOLVED:] Can I shorten This (9 replies)
  77. [SOLVED:] Issue with large multiplication on code (3 replies)
  78. [SOLVED:] Getting a VBA-Created Date to Format Correctly (3 replies)
  79. [SOLVED:] Code Efficiency (3 replies)
  80. [SOLVED:] Sort listbox and select with combobox (4 replies)
  81. [SOLVED:] Add static line to XYScatter graph (0 replies)
  82. [SOLVED:] Formatting EXCEL (1 replies)
  83. [SOLVED:] Create Folder (3 replies)
  84. Sleeper: The Case of the Disappearing Continuation Symbol (0 replies)
  85. Sleeper: Open txt file on website (3 replies)
  86. [SOLVED:] Please wait... Message box (4 replies)
  87. Sleeper: Supress All Excel Messages (4 replies)
  88. Sleeper: Launch Word to Merge with "This" Excel File (2 replies)
  89. Sleeper: Function Speed testing.. (5 replies)
  90. [SOLVED:] How to Switch from Worksheet to VBE Screen (9 replies)
  91. [SOLVED:] Prompt Box (38 replies)
  92. [SOLVED:] Slow calculating (14 replies)
  93. Sleeper: Error message pivot table is not valid (1 replies)
  94. [SOLVED:] Create Excel addin (4 replies)
  95. [SOLVED:] Sort sheets (6 replies)
  96. [SOLVED:] Nested IF formula question (5 replies)
  97. [SOLVED:] Accessing multiple files for 1 report (7 replies)
  98. [SOLVED:] Case Statements- General Question (10 replies)
  99. Sleeper: Personal.xls macros "not available" (4 replies)
  100. [SOLVED:] Copying Formulas (5 replies)
  101. [SOLVED:] XL 2003 Calendar Control Problem (8 replies)
  102. [SOLVED:] Save xls Sheet as txt file (2 replies)
  103. [SOLVED:] How Does the RGB (Color) Fctn Work? (2 replies)
  104. [SOLVED:] Performing a cell-specific action in a "do until" loop (3 replies)
  105. [SOLVED:] Conditional hiding of rows Part II (8 replies)
  106. [SOLVED:] Filling in Empty Rows with whats in the row above --HELP (13 replies)
  107. [SOLVED:] combining worksheets macro (14 replies)
  108. [SOLVED:] Invalid Reference (Macro) (10 replies)
  109. [SOLVED:] Macros to add rows and subtotals (4 replies)
  110. [SOLVED:] Subtraction formula help (4 replies)
  111. [SOLVED:] Userform ListBox (2 replies)
  112. Sleeper: Range (3 replies)
  113. [SOLVED:] "File In Use" problem (15 replies)
  114. [SOLVED:] Greenbar Look Report (5 replies)
  115. [SOLVED:] Positioning an AutoShape on the Worksheet (11 replies)
  116. [SOLVED:] Need help with a Formula (4 replies)
  117. [SOLVED:] Date problem (3 replies)
  118. [SOLVED:] Conflict Protect and WS_Calculation (4 replies)
  119. [SOLVED:] Create drop down menu in toolbar (6 replies)
  120. [SOLVED:] Open a workbook without knowing it's name. (3 replies)
  121. Sleeper: Increment Lines in a formula (3 replies)
  122. Solved: auto open password protected excel file (3 replies)
  123. [SOLVED:] problem with changing colour (4 replies)
  124. [SOLVED:] Setting .SubTotal TotalList via VBA (2 replies)
  125. [SOLVED:] "Ambiguous Name Detected" Problem (0 replies)
  126. [SOLVED:] Problem with an awfull lot off checkboxes (2 replies)
  127. [SOLVED:] Getting the Name of the Calling Macro (2 replies)
  128. [SOLVED:] Getting the Name of Executing Macro (7 replies)
  129. Advice: Creating a licensing method (10 replies)
  130. [SOLVED:] Define name for a dynamic list (15 replies)
  131. [SOLVED:] What Does This VBA Syntax Mean? (5 replies)
  132. [SOLVED:] Copying data from first worksheet and populating other sheets (4 replies)
  133. [SOLVED:] Build Word Table From Excel Spreadsheet (3 replies)
  134. [SOLVED:] Help with Unlocking a locked worksheet and breaking Links (2 replies)
  135. [SOLVED:] Recognizing column name (2 replies)
  136. [SOLVED:] Copy sheets from one workbook to another (8 replies)
  137. [SOLVED:] Totaling a column that changes length with blank cells (13 replies)
  138. [SOLVED:] Tables everywhere (7 replies)
  139. [SOLVED:] Loop through sheet (10 replies)
  140. Sleeper: Real N00B help about free cells (7 replies)
  141. [SOLVED:] Command button and a recorded macro (9 replies)
  142. [SOLVED:] Is There a "Find" for the VBA Macro List? (9 replies)
  143. [SOLVED:] Quick & Easy- (3 replies)
  144. [SOLVED:] Transfer data between sheets (8 replies)
  145. Sleeper: Simple database userforms (1 replies)
  146. [SOLVED:] I need a shortcut (because my method requires too much typing!) (8 replies)
  147. [SOLVED:] Unhide a paticular sheet (10 replies)
  148. [SOLVED:] Get Weight of border of top left cell of a range (3 replies)
  149. Sleeper: Show Code Pane in Main Window (2 replies)
  150. [SOLVED:] Self define function shows error (6 replies)
  151. [SOLVED:] Compile Error (4 replies)
  152. [SOLVED:] Unable to add data to List and Comboboxes (7 replies)
  153. [SOLVED:] Finding all ranges EXCEPT those with color fill (6 replies)
  154. [SOLVED:] Set rng as Multiple Ranges (5 replies)
  155. [SOLVED:] Message box if number sequence matches (5 replies)
  156. Sleeper: Suppress default drag&drop? (0 replies)
  157. Sleeper: Formulas not working (1 replies)
  158. Sleeper: Check IF Process Running (3 replies)
  159. [SOLVED:] Uploading a spreadsheet for assistance (1 replies)
  160. [SOLVED:] Conditional Format for ISBLANK (3 replies)
  161. [SOLVED:] Automate Menu Options Insert - Name - Define (12 replies)
  162. [SOLVED:] An alternative to sheet protection (19 replies)
  163. [SOLVED:] Prevent automatic updating (3 replies)
  164. Sleeper: Text Formulas, Macros, Cleaner Tools (1 replies)
  165. [SOLVED:] Kill/Close that open file (4 replies)
  166. Sleeper: Copy and paste in userform textbox (1 replies)
  167. File size too big (3 replies)
  168. [SOLVED:] IF statements using DATE values (4 replies)
  169. [SOLVED:] Conditional hiding of rows with multiple Ifs (9 replies)
  170. [SOLVED:] Relieve Reptitive Stress (14 replies)
  171. [SOLVED:] How to Copy VBA Help Examples to Editor (4 replies)
  172. Sleeper: Change login path for distributing other loggers (8 replies)
  173. [SOLVED:] Preceed or Append data to the selected cell(s) (1 replies)
  174. Sleeper: Find and Open Files (4 replies)
  175. [SOLVED:] Copy Rows to Another Sheet Macro (4 replies)
  176. Sleeper: Combining event handler and Activex control formatting (5 replies)
  177. [SOLVED:] Solved: Find function (15 replies)
  178. [SOLVED:] Detecting the Interior Color of a Cell (9 replies)
  179. [SOLVED:] How to Format Comment Connector Line (2 replies)
  180. [SOLVED:] All possible ouputs of TypeName(Selection)? (2 replies)
  181. Solved: Push Values to Bookmarks in Word (6 replies)
  182. [SOLVED:] Different areas to be unpdated by different usergroups (6 replies)
  183. [SOLVED:] Write to PDF (3 replies)
  184. Sleeper: Find and replace txtbox in toolbar (2 replies)
  185. [SOLVED:] What is wrong here. (3 replies)
  186. [SOLVED:] Where to get Activex calendar control? (17 replies)
  187. [SOLVED:] Length of text within cells (7 replies)
  188. Sleeper: Move to different cell based on selection (2 replies)
  189. Sleeper: Delete rows in mailmerge data source (9 replies)
  190. [SOLVED:] Hide Excel application and show just a Userform (4 replies)
  191. [SOLVED:] IF Statement in EXCEL (2 replies)
  192. [SOLVED:] Add worksheet (2 replies)
  193. [SOLVED:] Dynamic Data Exchange Code (1 replies)
  194. [SOLVED:] Add macro to menu items (1 replies)
  195. [SOLVED:] Lookup and update between two workbooks (7 replies)
  196. [SOLVED:] Email Priority (5 replies)
  197. [SOLVED:] Simplify and automate (3 replies)
  198. [SOLVED:] Which is faster? (11 replies)
  199. [SOLVED:] Filling missing data from a table based on criteria (9 replies)
  200. [SOLVED:] What Is VB IDE? (8 replies)
  201. [SOLVED:] Find next available empty cell/row (20 replies)
  202. [SOLVED:] Lookup value in seperate workbook (5 replies)
  203. Solved: Using for next loop (2 replies)
  204. [SOLVED:] Write a Macro to Modify a Macro (4 replies)
  205. [SOLVED:] Copy from Excel to Word (2 replies)
  206. [SOLVED:] change font colour in a row according to cell value (4 replies)
  207. [SOLVED:] Left Overs (1 replies)
  208. [SOLVED:] When does Exit Sub not Exit Sub? (3 replies)
  209. [SOLVED:] Querrytable refresh (3 replies)
  210. [SOLVED:] Looping Question (14 replies)
  211. [SOLVED:] Importing content (54 replies)
  212. Sleeper: Find all macros used (4 replies)
  213. Sleeper: Copying Data between Workbooks (1 replies)
  214. [SOLVED:] Having a list without a userform (13 replies)
  215. [SOLVED:] Merge cells with alive data & seprators (19 replies)
  216. [SOLVED:] Combo box (2 replies)
  217. [SOLVED:] How do I insert a formula (7 replies)
  218. [SOLVED:] Workbook protection with an exception (14 replies)
  219. [SOLVED:] Stop if one of three conditions are true (4 replies)
  220. [SOLVED:] How to Rename a VBA Module (2 replies)
  221. Solved: Where have all the add-ins gone? (3 replies)
  222. Solved: Need to know how to Unprotect all sheets at once with a macro (6 replies)
  223. [SOLVED:] Change to a Specified Range (10 replies)
  224. [SOLVED:] Save wookbook as now() function (6 replies)
  225. [SOLVED:] Reversed P in Excel (6 replies)
  226. [SOLVED:] This works but I know it can be written better (5 replies)
  227. [SOLVED:] Selecting Word reference library (11 replies)
  228. [SOLVED:] Save Active Worksheet - Sever All Links (12 replies)
  229. Sleeper: Changing the order of the data columns (1 replies)
  230. [SOLVED:] Need a procedure to clear styles. (32 replies)
  231. [SOLVED:] How do I select more than one sheet and send as workbook (6 replies)
  232. [SOLVED:] Protect method (4 replies)
  233. Help with a mailmerge list (28 replies)
  234. Sleeper: How to call or execute a program from excel Vba editors? (2 replies)
  235. [SOLVED:] Textboxes - more problems (10 replies)
  236. [SOLVED:] Find the code behind (16 replies)
  237. [SOLVED:] Trapping Group/Ungroup Event (8 replies)
  238. Updating shared workbook (1 replies)
  239. [SOLVED:] On Error ... (7 replies)
  240. [SOLVED:] I need help with the file path script (14 replies)
  241. [SOLVED:] Transfer paragraph(s) (14 replies)
  242. [SOLVED:] Having some trouble with the find function (8 replies)
  243. [SOLVED:] Immediate Window statements (10 replies)
  244. [SOLVED:] defining and handling of parameters (1 replies)
  245. [SOLVED:] Cannot switch between Userform to Excel Workbook (7 replies)
  246. [SOLVED:] page break code (7 replies)
  247. [SOLVED:] My workbook stopped recalculating! (3 replies)
  248. [SOLVED:] Can these instructions be consolidated? (5 replies)
  249. [SOLVED:] Hiding columns with a checkbox toggle (3 replies)
  250. [SOLVED:] Disabling Reviewing Toolbar (2 replies)