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. Sleeper: SQUARE of the difference from two columns (1 replies)
  2. [SOLVED:] Counting like cells to determine coverage (1 replies)
  3. Sleeper: Two comboboxes update puzzle (1 replies)
  4. [SOLVED:] Sorting drop down box output (4 replies)
  5. Sleeper: How to change automatically the format of a range of cells? (6 replies)
  6. Sleeper: Cell References & Links - Please help (8 replies)
  7. [SOLVED:] Metmorphisis of a Variable Into an Array (11 replies)
  8. [SOLVED:] Can't Find Shortcut Notation Using Prefixes (7 replies)
  9. Solved: Add an item for MACROS to the Excel menu bar (22 replies)
  10. [SOLVED:] Advanced Filter (14 replies)
  11. Sleeper: UserForm Error from Thin Air (4 replies)
  12. Sleeper: VBA - sort data (7 replies)
  13. [SOLVED:] Working with "time" (10 replies)
  14. Sleeper: How to sort my data using VBA? (1 replies)
  15. [SOLVED:] Range Address (24 replies)
  16. [SOLVED:] Assigning a Macro to a VBE Toolbar Button (4 replies)
  17. [SOLVED:] Function average using VBA (12 replies)
  18. [SOLVED:] Conditional Format Cells (47 replies)
  19. Sleeper: Problem Pivot table &VBA (2 replies)
  20. [SOLVED:] Balance Forward Method (6 replies)
  21. Sleeper: Extract file using vba macro (2 replies)
  22. [SOLVED:] Protect sheet on idle (3 replies)
  23. Sleeper: Looking for guidance on saving file (2 replies)
  24. [SOLVED:] The Quest For How to Insert a Line in a Macro (4 replies)
  25. Sleeper: VBA problem activate window inside a window (4 replies)
  26. Sleeper: input values in appropiate textbox on first userform (2 replies)
  27. [SOLVED:] Return path (3 replies)
  28. [SOLVED:] Values Adding (4 replies)
  29. [SOLVED:] Range all sheets to cell "A1" before closing file (3 replies)
  30. Sleeper: Display data in UserForm (4 replies)
  31. [SOLVED:] VBA code: FILTER DATA (7 replies)
  32. [SOLVED:] Insert lines in two or more sheets at the same time (2 replies)
  33. [SOLVED:] Automatically change Lowercase to Uppercase (20 replies)
  34. Disable Password/Login Request on Web Query (2 replies)
  35. Range Names : Good or Bad programming practice? (121 replies)
  36. Sleeper: Range Names: Good or Bad? (5 replies)
  37. [SOLVED:] how to move a selection area? (5 replies)
  38. [SOLVED:] Formula to match non case sensitive text (7 replies)
  39. [SOLVED:] Is it possible to display the highlight text in VBE (16 replies)
  40. [SOLVED:] Excel / Word / E-mail (10 replies)
  41. Sleeper: How Can I create a Pivot table using VBA? (1 replies)
  42. Disable Insert Worksheet Command from toolbar (10 replies)
  43. [SOLVED:] Any Extra Execution Time? (4 replies)
  44. [SOLVED:] Help with excel macro (13 replies)
  45. [SOLVED:] Determining "Local" Directory (2 replies)
  46. [SOLVED:] Blank Cells with Formula (2 replies)
  47. Sleeper: Blank Cells with Formula (1 replies)
  48. Sleeper: Changing Print Range with Protection (2 replies)
  49. [SOLVED:] Counting Cells (4 replies)
  50. [SOLVED:] Compare two columns to two other columns (3 replies)
  51. Sleeper: Updating Links from Files with Passwords (3 replies)
  52. Sleeper: Create a Fixed Table (1 replies)
  53. Condional format (3 replies)
  54. Sleeper: Memory Issue (3 replies)
  55. [SLEEPER:] Printing in VBA (1 replies)
  56. [SOLVED:] Div/0! Question (2 replies)
  57. [SOLVED:] Perform a "Find" on 2 criteria on an "or" basis (7 replies)
  58. [SOLVED:] Counter, part II (4 replies)
  59. [SOLVED:] Protecting Page SetUp Properties (3 replies)
  60. Sleeper: Help with Zip Codes (5 replies)
  61. [SOLVED:] Add new line to .txt file (3 replies)
  62. [SOLVED:] Scrolling multiple sheets to the same row (4 replies)
  63. [SOLVED:] Counter (3 replies)
  64. [SOLVED:] Shared Workbook - How can macro work? (2 replies)
  65. Sleeper: Setting VBA Project Password in Code (2 replies)
  66. [SOLVED:] Does knowledge of Visual Basic.NEt help with VBA? (14 replies)
  67. Sleeper: Help with Excel and reflection script (1 replies)
  68. [SOLVED:] Need a macro to change font in unique cells (6 replies)
  69. Solved: Protect/Unprotect Cells with VBA (4 replies)
  70. [SOLVED:] Fill in data from Search routine (2 replies)
  71. Sleeper: Simple Print Word doc from Excel (4 replies)
  72. Solved: Pls HELP!! w/ email a worksheet (19 replies)
  73. [SOLVED:] Search a worksheet (5 replies)
  74. [SOLVED:] Easy sort question (4 replies)
  75. [SOLVED:] working with named ranges & automated labelling (4 replies)
  76. [SOLVED:] DisplayAlerts (3 replies)
  77. [SOLVED:] Doubt about Hlookup (6 replies)
  78. Sleeper: Hyperlink issue (3 replies)
  79. [SOLVED:] Create a Mailing List from unformatted data (6 replies)
  80. [SOLVED:] Goto a specific part of a list (4 replies)
  81. [SOLVED:] Removing password on excel file (3 replies)
  82. [SOLVED:] Enable/Disable Macro POPUP question (7 replies)
  83. Solved: Naming rows according to data in column A (11 replies)
  84. [SOLVED:] Remove asterisk symbol (3 replies)
  85. [SOLVED:] Drop down list excel 2000 (3 replies)
  86. [SOLVED:] Help with error (3 replies)
  87. [SOLVED:] Sort new record after add (17 replies)
  88. [SOLVED:] deleting rows with zeros (7 replies)
  89. Solved: Erasing a link (3 replies)
  90. Sleeper: Pivot Table Too Large (1 replies)
  91. [SOLVED:] Insert a value into a cell after a row has been inserted. (5 replies)
  92. [SOLVED:] Loging invoices/quotes (15 replies)
  93. Sleeper: Looking for a data validation-like function (1 replies)
  94. Sleeper: Link updates (1 replies)
  95. VBA question (1 replies)
  96. [SOLVED:] Excel Userform List box question (2 replies)
  97. [SOLVED:] Saving as .csv with parmaeters (5 replies)
  98. [SOLVED:] HLookup without sorted data? (1 replies)
  99. [SOLVED:] Delete Range With Condition (6 replies)
  100. [SOLVED:] Sleeper: Control Range Scanned (1 replies)
  101. [SOLVED:] Tabbing in a user form (4 replies)
  102. [SOLVED:] Simple question about strings? (7 replies)
  103. Sleeper: Linking a Hyperlink (info inside) (4 replies)
  104. [SOLVED:] Delete sheet without prompting (2 replies)
  105. Sleeper: Merge dynamic array list (6 replies)
  106. [SOLVED:] Is the name found in both lists? (3 replies)
  107. [SOLVED:] Add New Sheet and Copy over data (5 replies)
  108. [SOLVED:] Mass Change Of Cond'l Fmting Variable Names (3 replies)
  109. [SOLVED:] Unique values (2 replies)
  110. [SOLVED:] Properties of Named Rectangles (5 replies)
  111. [SLEEPER:] Question about links (1 replies)
  112. Sleeper: Shift Columns Down (3 replies)
  113. [SOLVED:] Move Macro buttons to a new sheet then sort (2 replies)
  114. [SOLVED:] Extract data from one workbook and copy and paste it to another (6 replies)
  115. [SOLVED:] Automatic re-sorting of data (7 replies)
  116. [SOLVED:] Inserting new slide in PP from Excel (3 replies)
  117. [SOLVED:] Gotta be a better way (6 replies)
  118. [SOLVED:] Sumif a weekly total (3 replies)
  119. Solved: Procedure "Sheet_Activate_1()" Does What? (9 replies)
  120. [SOLVED:] Help - A question from Ella. (3 replies)
  121. [SOLVED:] Insert row based on string (5 replies)
  122. [SOLVED:] Estimate End Result (9 replies)
  123. [SOLVED:] What is the code for the current date? (11 replies)
  124. [SOLVED:] Protecting an excel file (3 replies)
  125. [SOLVED:] Print Preview (4 replies)
  126. Sleeper: Problematic queries (2 replies)
  127. Sleeper: Remove duplications (8 replies)
  128. [SOLVED:] If I want to change the contents in the cell (9 replies)
  129. Sleeper: Click Button to select Button's Cell (4 replies)
  130. [SOLVED:] How Do You Make the "Beep" API Work? (4 replies)
  131. [SOLVED:] Color cell dependant on other cell value (4 replies)
  132. Sleeper: SQL and Excel (1 replies)
  133. [SOLVED:] Print report from Listbox (10 replies)
  134. Sleeper: Running Multiple Macros from a command button (3 replies)
  135. Sleeper: Using part cell to lookup refs (11 replies)
  136. [SOLVED:] Check mysheet is active (4 replies)
  137. [SOLVED:] Norton alert with vbs (3 replies)
  138. [SOLVED:] Converting a database from Excel to Access (4 replies)
  139. Sleeper: Charting Hell (4 replies)
  140. Sleeper: Array formula (18 replies)
  141. [SOLVED:] Run a macro from info on another sheet (2 replies)
  142. [SOLVED:] Examining the Formula in a Cell (3 replies)
  143. [SOLVED:] Solved: Tell Me About VB Script (5 replies)
  144. Sleeper: Any way to fix the scale ( inches / mm / cm ) of chart or excel sheet ? (2 replies)
  145. [SOLVED:] Updating blank only cells (4 replies)
  146. [SOLVED:] Remove duplications (3 replies)
  147. [SOLVED:] Assigning a macro a shortcut from the desktop (1 replies)
  148. [SOLVED:] Invert numbers (2 replies)
  149. [SOLVED:] How to create a drop down list. (19 replies)
  150. [SOLVED:] Break at First Number in String (11 replies)
  151. [SOLVED:] Can This Expression Be Simplified? (5 replies)
  152. [SOLVED:] What's Wrong With This "WhatIf"? (2 replies)
  153. [SOLVED:] Search list with Vlookup (7 replies)
  154. [SOLVED:] Follow up on code provided by C. Paleo (20 replies)
  155. [SOLVED:] Copying a range of cells of active worksheet to a new workbook (3 replies)
  156. Sleeper: Update list from a ranges input (19 replies)
  157. [SOLVED:] Error: AutoFilter method of Range Class failed (27 replies)
  158. [SOLVED:] How do I put insert Linebreak (2 replies)
  159. [SOLVED:] Error I recieved!! (2 replies)
  160. Solved: Force string array to return text, not numbers? (2 replies)
  161. Sleeper: Poker discussion / odds (9 replies)
  162. [SOLVED:] What is equivalent to "or" in VBA? (17 replies)
  163. [SOLVED:] Easy question (3 replies)
  164. [SOLVED:] Rank (4 replies)
  165. [SOLVED:] get latest? (3 replies)
  166. [SOLVED:] Run/Test Code Without Printing (13 replies)
  167. [SOLVED:] Need help to create macro (4 replies)
  168. [SOLVED:] I tried to run a macro and it gave this error (3 replies)
  169. [SOLVED:] Need help to shorten The DeleteEdsMenuItems (4 replies)
  170. [SOLVED:] Need help with hiding row under the following circumstances (21 replies)
  171. [SOLVED:] Can I shorten This (9 replies)
  172. [SOLVED:] Issue with large multiplication on code (3 replies)
  173. [SOLVED:] Getting a VBA-Created Date to Format Correctly (3 replies)
  174. [SOLVED:] Code Efficiency (3 replies)
  175. [SOLVED:] Sort listbox and select with combobox (4 replies)
  176. [SOLVED:] Add static line to XYScatter graph (0 replies)
  177. [SOLVED:] Formatting EXCEL (1 replies)
  178. [SOLVED:] Create Folder (3 replies)
  179. Sleeper: The Case of the Disappearing Continuation Symbol (0 replies)
  180. Sleeper: Open txt file on website (3 replies)
  181. [SOLVED:] Please wait... Message box (4 replies)
  182. Sleeper: Supress All Excel Messages (4 replies)
  183. Sleeper: Launch Word to Merge with "This" Excel File (2 replies)
  184. Sleeper: Function Speed testing.. (5 replies)
  185. [SOLVED:] How to Switch from Worksheet to VBE Screen (9 replies)
  186. [SOLVED:] Prompt Box (38 replies)
  187. [SOLVED:] Slow calculating (14 replies)
  188. Sleeper: Error message pivot table is not valid (1 replies)
  189. [SOLVED:] Create Excel addin (4 replies)
  190. [SOLVED:] Sort sheets (6 replies)
  191. [SOLVED:] Nested IF formula question (5 replies)
  192. [SOLVED:] Accessing multiple files for 1 report (7 replies)
  193. [SOLVED:] Case Statements- General Question (10 replies)
  194. Sleeper: Personal.xls macros "not available" (4 replies)
  195. [SOLVED:] Copying Formulas (5 replies)
  196. [SOLVED:] XL 2003 Calendar Control Problem (8 replies)
  197. [SOLVED:] Save xls Sheet as txt file (2 replies)
  198. [SOLVED:] How Does the RGB (Color) Fctn Work? (2 replies)
  199. [SOLVED:] Performing a cell-specific action in a "do until" loop (3 replies)
  200. [SOLVED:] Conditional hiding of rows Part II (8 replies)
  201. [SOLVED:] Filling in Empty Rows with whats in the row above --HELP (13 replies)
  202. [SOLVED:] combining worksheets macro (14 replies)
  203. [SOLVED:] Invalid Reference (Macro) (10 replies)
  204. [SOLVED:] Macros to add rows and subtotals (4 replies)
  205. [SOLVED:] Subtraction formula help (4 replies)
  206. [SOLVED:] Userform ListBox (2 replies)
  207. Sleeper: Range (3 replies)
  208. [SOLVED:] "File In Use" problem (15 replies)
  209. [SOLVED:] Greenbar Look Report (5 replies)
  210. [SOLVED:] Positioning an AutoShape on the Worksheet (11 replies)
  211. [SOLVED:] Need help with a Formula (4 replies)
  212. [SOLVED:] Date problem (3 replies)
  213. [SOLVED:] Conflict Protect and WS_Calculation (4 replies)
  214. [SOLVED:] Create drop down menu in toolbar (6 replies)
  215. [SOLVED:] Open a workbook without knowing it's name. (3 replies)
  216. Sleeper: Increment Lines in a formula (3 replies)
  217. Solved: auto open password protected excel file (3 replies)
  218. [SOLVED:] problem with changing colour (4 replies)
  219. [SOLVED:] Setting .SubTotal TotalList via VBA (2 replies)
  220. [SOLVED:] "Ambiguous Name Detected" Problem (0 replies)
  221. [SOLVED:] Problem with an awfull lot off checkboxes (2 replies)
  222. [SOLVED:] Getting the Name of the Calling Macro (2 replies)
  223. [SOLVED:] Getting the Name of Executing Macro (7 replies)
  224. Advice: Creating a licensing method (10 replies)
  225. [SOLVED:] Define name for a dynamic list (15 replies)
  226. [SOLVED:] What Does This VBA Syntax Mean? (5 replies)
  227. [SOLVED:] Copying data from first worksheet and populating other sheets (4 replies)
  228. [SOLVED:] Build Word Table From Excel Spreadsheet (3 replies)
  229. [SOLVED:] Help with Unlocking a locked worksheet and breaking Links (2 replies)
  230. [SOLVED:] Recognizing column name (2 replies)
  231. [SOLVED:] Copy sheets from one workbook to another (8 replies)
  232. [SOLVED:] Totaling a column that changes length with blank cells (13 replies)
  233. [SOLVED:] Tables everywhere (7 replies)
  234. [SOLVED:] Loop through sheet (10 replies)
  235. Sleeper: Real N00B help about free cells (7 replies)
  236. [SOLVED:] Command button and a recorded macro (9 replies)
  237. [SOLVED:] Is There a "Find" for the VBA Macro List? (9 replies)
  238. [SOLVED:] Quick & Easy- (3 replies)
  239. [SOLVED:] Transfer data between sheets (8 replies)
  240. Sleeper: Simple database userforms (1 replies)
  241. [SOLVED:] I need a shortcut (because my method requires too much typing!) (8 replies)
  242. [SOLVED:] Unhide a paticular sheet (10 replies)
  243. [SOLVED:] Get Weight of border of top left cell of a range (3 replies)
  244. Sleeper: Show Code Pane in Main Window (2 replies)
  245. [SOLVED:] Self define function shows error (6 replies)
  246. [SOLVED:] Compile Error (4 replies)
  247. [SOLVED:] Unable to add data to List and Comboboxes (7 replies)
  248. [SOLVED:] Finding all ranges EXCEPT those with color fill (6 replies)
  249. [SOLVED:] Set rng as Multiple Ranges (5 replies)
  250. [SOLVED:] Message box if number sequence matches (5 replies)