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:] Formula to change text colour and add a value to another cell (8 replies)
  2. [SOLVED:] Simple IF with Worksheet Change Event (3 replies)
  3. [SOLVED:] vba to copy selection of csv file to Workbook (7 replies)
  4. [SOLVED:] I want to create a Macro That will save (2 replies)
  5. [SOLVED:] Excel 97 - want to automatically move data (3 replies)
  6. Sleeper: Querytables.add with multiple request (range get confused) (3 replies)
  7. [SOLVED:] Can't figure it out (18 replies)
  8. Sleeper: Merge Excel data to Word document (4 replies)
  9. [SOLVED:] Max no. of worksheets (8 replies)
  10. [SOLVED:] What is the maximum length for a procedure (16 replies)
  11. Sleeper: Ask for a password before filtering (3 replies)
  12. [SOLVED:] Populating a Combobox according to cell values (2 replies)
  13. [SOLVED:] Copy active sheet & Clear unlocked cells on new sheet (7 replies)
  14. [SOLVED:] Code returning error '1004' (15 replies)
  15. [SOLVED:] Single line array/loop??? (7 replies)
  16. Sleeper: Follow-Up Timesheet Query (2 replies)
  17. [SOLVED:] On Error Help (6 replies)
  18. Sleeper: SendKeys Issue (1 replies)
  19. [SOLVED:] Array Formula to Compare Columns and Return Unique Entries (6 replies)
  20. [SOLVED:] Paste to specific cell resulting from formula (4 replies)
  21. Sleeper: FileCopy not helping (1 replies)
  22. Sleeper: For review (2 replies)
  23. [SOLVED:] Easy code (7 replies)
  24. Sleeper: Tempremental coding? (2 replies)
  25. [SOLVED:] Help VBA alternative to DGET (1 replies)
  26. [SOLVED:] add a sheet (actually one already created) (5 replies)
  27. [SOLVED:] Countdown inside a cell with a 1 second delay (7 replies)
  28. [SOLVED:] Moving from sheet to sheet (6 replies)
  29. [SOLVED:] Protection for Excel Sheet (8 replies)
  30. Sleeper: Error in built-in dialog xlDialogPrinterSetup (1 replies)
  31. Sleeper: Listbox (1 replies)
  32. Sleeper: Image following Scroll Bar movements (2 replies)
  33. [SOLVED:] Solved: Keeping formulas (7 replies)
  34. [SOLVED:] Array Average not working right.. (2 replies)
  35. [SOLVED:] interesting question (11 replies)
  36. [SOLVED:] Weekday formatting (5 replies)
  37. Sleeper: Enable Auto Filter (12 replies)
  38. Solved: Closing an Excel Workbook without "Save" Prompt (2 replies)
  39. Sleeper: Possible to search Excel columns? (5 replies)
  40. [SOLVED:] Sheet continuation (6 replies)
  41. Sleeper: The two lines problem (8 replies)
  42. Sleeper: Email Code issue (5 replies)
  43. [SOLVED:] Difficult one!!! (41 replies)
  44. [SOLVED:] Assistance required (3 replies)
  45. [SOLVED:] Printing Suggestions (13 replies)
  46. [SOLVED:] Variants as Array (7 replies)
  47. Sleeper: Help with Renaming Excel Files & Toolbars.. (2 replies)
  48. [SOLVED:] Line graphs in Excel (10 replies)
  49. [SOLVED:] Copy Unique records to another location (9 replies)
  50. [SOLVED:] Printing a series of records (8 replies)
  51. [SOLVED:] Keeping Formulas after edit (15 replies)
  52. [SOLVED:] Testers Wanted (13 replies)
  53. [SOLVED:] Minimizing UserForms (8 replies)
  54. Sleeper: Change excel icon (8 replies)
  55. [SOLVED:] Can you sell a VB coded Excel spreadsheet? (17 replies)
  56. [SOLVED:] Inputbox search on specify sheets (20 replies)
  57. Solved: Convert Cell to Hyperlink (3 replies)
  58. [SOLVED:] LastModified = 5 minutes (???) (4 replies)
  59. [SOLVED:] Stoping a workbook from opening when macros are disabled? (5 replies)
  60. Sleeper: Delete row when condition is true (11 replies)
  61. [SOLVED:] Correct syntax for Worksheetfunction.vlookup? (5 replies)
  62. Sleeper: Password protect VBA Project in Script (27 replies)
  63. [SOLVED:] Compute Date (2 replies)
  64. Sleeper: VBA Filtering (7 replies)
  65. Sleeper: Sorting Data (4 replies)
  66. Sleeper: Inserting into a named range (1 replies)
  67. Sleeper: Copy Ranges from many sheets to one (1 replies)
  68. Sleeper: Copying UserForm under VBA Control (11 replies)
  69. Solved: "This File was created in a later version" (46 replies)
  70. Sleeper: Converting to PDF (3 replies)
  71. Advice: Using a Cert for SSL (4 replies)
  72. [SOLVED:] Transpose (14 replies)
  73. [SOLVED:] How to call/run a macro from other workbook? (2 replies)
  74. [SOLVED:] Suffixes for sub command (9 replies)
  75. [SOLVED:] Macro to open Word and Start Mail Merge (2 replies)
  76. [SOLVED:] Background on Excel (6 replies)
  77. [SOLVED:] Copy selected columns to new sheets. (4 replies)
  78. [SOLVED:] Passing Sub Name as argument (11 replies)
  79. [SOLVED:] Create new directory for today's date (10 replies)
  80. Sleeper: return the source of the input of a combobox (11 replies)
  81. [SOLVED:] Sorting worksheets alphabetically (7 replies)
  82. [SOLVED:] Help with macro to bold word (2 replies)
  83. [SOLVED:] Can I increase date/time with +/- key (14 replies)
  84. [SOLVED:] Changeing links source with VBA (3 replies)
  85. [SOLVED:] Help with Number Custom Format (3 replies)
  86. [SOLVED:] Exporting to Excel (2 replies)
  87. Sleeper: auto add formula (3 replies)
  88. [SOLVED:] Simple question (5 replies)
  89. Sleeper: Macro to copy data from a text file and place data in Excel (1 replies)
  90. [SOLVED:] Cap sensitive search (8 replies)
  91. [SOLVED:] Problem with Web Service (2 replies)
  92. [SOLVED:] Show Value When Range is Not Empty (4 replies)
  93. Sleeper: Help With Userform Search Box (14 replies)
  94. VSTO (35 replies)
  95. [SOLVED:] Integer, Byte or Long for Columns? (29 replies)
  96. [SOLVED:] Problems with Save As (1 replies)
  97. Sleeper: Show userform, save > ...Illegal operation ? (15 replies)
  98. [SOLVED:] Improve Nested IF Formula (12 replies)
  99. [SOLVED:] Remove Cancel button - Input boxes (5 replies)
  100. [SOLVED:] Cannot Launch Data Form with Macro (3 replies)
  101. [SOLVED:] Problem with a increment (5 replies)
  102. [SOLVED:] How do I move a date exactly one month forward (6 replies)
  103. Solved: Creating new folder & saving copy as: (15 replies)
  104. [SOLVED:] Where to Store Auto_Open Macros? (14 replies)
  105. [SOLVED:] Improving Code to Convert HTML to Text (19 replies)
  106. Sleeper: Excel to word (1 replies)
  107. [SOLVED:] Timed Sub (21 replies)
  108. [SOLVED:] Help with a combobox! (8 replies)
  109. [SOLVED:] Converting large decimals to hex (8 replies)
  110. [SOLVED:] Tab order Problem "for the Brave" Protected sheet!! (4 replies)
  111. [SOLVED:] Problem with an if code (2 replies)
  112. Sleeper: Insert Scroll bar from code (3 replies)
  113. Sleeper: Staffing Roster Automation (8 replies)
  114. Sleeper: Testers wanted (16 replies)
  115. [SOLVED:] Printing chart objects (2 replies)
  116. [SOLVED:] Copy if date => now() <= Now() + 7 ? (7 replies)
  117. [SOLVED:] Strange sort problem (20 replies)
  118. [SOLVED:] Linking filters (5 replies)
  119. [SOLVED:] Problem with a do loop (1 replies)
  120. [SOLVED:] Option Button "Linked Cell" Property (12 replies)
  121. [SOLVED:] Average and plot help - NEWBIE (5 replies)
  122. [SOLVED:] Evergoing calendar (6 replies)
  123. [SOLVED:] Strange format problem !!! (3 replies)
  124. [SOLVED:] Hiding rows depending on data in first cell (14 replies)
  125. [SOLVED:] Search PDF files (11 replies)
  126. [SOLVED:] Custom toolbar problem (8 replies)
  127. [SOLVED:] Replace save with save as (10 replies)
  128. [SOLVED:] Save As? (2 replies)
  129. [SOLVED:] Changing Font Color (9 replies)
  130. [SOLVED:] Type Mismatch in Excel 2003 (9 replies)
  131. [SOLVED:] Help with Procedure to View Web Page (6 replies)
  132. Sleeper: Need help with code to controll itemsvisibility in datafield/pivottable (0 replies)
  133. Solved: VBA: Converting Worksheet_change sub into Addin (3 replies)
  134. [SOLVED:] Ordering against a forecast according to lead-time (21 replies)
  135. [SOLVED:] Help with a loop error (3 replies)
  136. [SOLVED:] Sum Except Last Register (5 replies)
  137. [SOLVED:] Making the next cell active (4 replies)
  138. Sleeper: Help refreshing data (6 replies)
  139. [SOLVED:] Conditional Formatting with VB (5 replies)
  140. [SOLVED:] Subtotaling a report (13 replies)
  141. Sleeper: Using a link (4 replies)
  142. Print UserForm with a Webbrower Control (9 replies)
  143. [SOLVED:] Macros take longer than usual (19 replies)
  144. [SOLVED:] Remove the password protection on a file (2 replies)
  145. [SOLVED:] For the gurus of EXCEL I think...... (7 replies)
  146. [SOLVED:] Formatting multiple occurences of words. (6 replies)
  147. [SOLVED:] Error alert if a certain limit is exceeded (14 replies)
  148. [SOLVED:] Conditional formatting (5 replies)
  149. Freezing Sheet Tabs - xl97 (4 replies)
  150. [SOLVED:] Outside of Excel ss (7 replies)
  151. [SOLVED:] Assigning a Macro to a Toolbar Button (16 replies)
  152. Sleeper: Tab sequence works if enter data, but if I dont... (3 replies)
  153. [SOLVED:] Problem with code. Please help. (8 replies)
  154. [SOLVED:] Count conditional formats (5 replies)
  155. [SLEEPER:] Excel Read Only Problem (5 replies)
  156. [SOLVED:] Strange Occcurance (9 replies)
  157. [SOLVED:] Problem after upgrade from Excel 97 to Excel 2000 (8 replies)
  158. [SOLVED:] Dates (18 replies)
  159. Sleeper: Print Macro (4 replies)
  160. [SOLVED:] Zoom to used range (3 replies)
  161. [SOLVED:] Save as new filename function (8 replies)
  162. [SOLVED:] Worksheet Protection with exceptions (7 replies)
  163. [SOLVED:] Password before running macro (12 replies)
  164. [SOLVED:] Specify Export Path (3 replies)
  165. [SOLVED:] Disable Macros (2 replies)
  166. Sleeper: Print Macro Not Working (5 replies)
  167. Sleeper: Opening another version of Excel (4 replies)
  168. [SOLVED:] Copy Worksheets and Formulae (7 replies)
  169. [SOLVED:] Password protection with exceptions (4 replies)
  170. [SOLVED:] Locking Drawing objects on screen (14 replies)
  171. [SOLVED:] How to insert a Reference in a sheet (3 replies)
  172. [SOLVED:] ComboBox (14 replies)
  173. [SOLVED:] Combobox populate (4 replies)
  174. [SOLVED:] Data sort automatic?? (4 replies)
  175. Sleeper: Validation drop-down arrows not on active cell! (3 replies)
  176. Solved: remove link to another spreadsheet (20 replies)
  177. Sleeper: Macro to Change Properties in all Files in a Folder (6 replies)
  178. [SOLVED:] Randomize (29 replies)
  179. [SOLVED:] Array not working (3 replies)
  180. [SOLVED:] Text to formula conversion/calculation (30 replies)
  181. [SOLVED:] Macro to transfer values (2 replies)
  182. [SOLVED:] Untidy Worksheet_SelectionChange code (5 replies)
  183. [SOLVED:] Download from web site (8 replies)
  184. [SOLVED:] How do I open variable file in Excel? (3 replies)
  185. [SOLVED:] Command button moves after print preview? (3 replies)
  186. Sleeper: Using a Macro to get fund data (28 replies)
  187. [SOLVED:] Move a copy of worksheets (10 replies)
  188. [SOLVED:] Password protection with exceptions (11 replies)
  189. [SOLVED:] Import Files With Too Many Rows (6 replies)
  190. [SOLVED:] When is a Global Variable not Global? (4 replies)
  191. Sleeper: A simple question (2 replies)
  192. [SOLVED:] Unhiding spreadhseets upon meeting a condition (5 replies)
  193. [SOLVED:] Calculation Problem (3 replies)
  194. [SOLVED:] Show full file path (3 replies)
  195. [SOLVED:] UserForm disables keyboard - ??? (4 replies)
  196. [SOLVED:] Adding a picture (12 replies)
  197. [SOLVED:] How to Code to accomplish this in Excel Chart? (5 replies)
  198. [SOLVED:] CountIf (2 replies)
  199. [SOLVED:] Drawing lines (31 replies)
  200. [SOLVED:] Copy columns to rows???? (18 replies)
  201. Sleeper: Cell Reference Problem in vertical layout (1 replies)
  202. [SOLVED:] Conditional hiding of rows (5 replies)
  203. [SOLVED:] Switching views when cell is changed (15 replies)
  204. [SOLVED:] CLOSE Event, random not closing (3 replies)
  205. [SOLVED:] Command Bars With Custom Face IDs (24 replies)
  206. [SOLVED:] Formula to extract info or VBA code (15 replies)
  207. [SOLVED:] Not clearing contents in hidden cells (8 replies)
  208. [SOLVED:] Selected row--->other workbook? (60 replies)
  209. [SOLVED:] date based on # days from starting date (4 replies)
  210. [SOLVED:] Comparing cells from different files (6 replies)
  211. [SOLVED:] Handle with activating of nonexisting sheet (3 replies)
  212. [SOLVED:] Active Sheet Save As??? (4 replies)
  213. [SOLVED:] Setting a range of cells (4 replies)
  214. [SOLVED:] Regexp question (8 replies)
  215. [SOLVED:] Multiple Sheets (1 replies)
  216. [SOLVED:] Using a &%$#%$ RefEdit box to work with a multi sheet range - solution or overkill? (3 replies)
  217. [SOLVED:] Creating two buttons and code programmatically (6 replies)
  218. [SOLVED:] Code review? (25 replies)
  219. Sleeper: Updating and copying? (3 replies)
  220. [SOLVED:] Scroll Bars (9 replies)
  221. Sleeper: Showing specific range when the specific value chosen (8 replies)
  222. [SOLVED:] Hidding Command Bars (10 replies)
  223. Sleeper: Repair Feature? (5 replies)
  224. [SOLVED:] Progress Bar (3 replies)
  225. [SOLVED:] Look up values of Excel in Access table (3 replies)
  226. [SOLVED:] "Save As" prompt (3 replies)
  227. [SOLVED:] Select Case (15 replies)
  228. [SOLVED:] Expand TreeView and select a node by parameter (5 replies)
  229. [SOLVED:] Changing orientation of word doc from excel (9 replies)
  230. [SOLVED:] Multi listbox (3 replies)
  231. [SOLVED:] Resizing Excel Application (3 replies)
  232. [SOLVED:] Moving and storing values between two listboxes and excel sheet (15 replies)
  233. [SOLVED:] Name a worksheet after a cell (12 replies)
  234. [SOLVED:] "Read Only" workbook (3 replies)
  235. [SOLVED:] Code not showing form (4 replies)
  236. [SOLVED:] Custom List Being Ignored (7 replies)
  237. [SOLVED:] I've lost my macro recorder toolbar (4 replies)
  238. [SOLVED:] Goto record using listbox (3 replies)
  239. [SOLVED:] Listbox problem (3 replies)
  240. [SOLVED:] Browse open workbooks (3 replies)
  241. [SOLVED:] Disable print (8 replies)
  242. [SOLVED:] Why doesn't Dr Watson like my code? (NT, XL97) (5 replies)
  243. [SOLVED:] Search sheet and list results in a doc (7 replies)
  244. [SOLVED:] create a directory then save the workbook into it (2 replies)
  245. [SOLVED:] Static Date Stamp (9 replies)
  246. Sleeper: Bug on Excel Footer??? (8 replies)
  247. [SOLVED:] This one should get u thinking (9 replies)
  248. [SOLVED:] Populating the TreeView (5 replies)
  249. [SOLVED:] This one may get you thinking!!!! (5 replies)
  250. [SOLVED:] Listbox navigation (3 replies)