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:] Compare 2 columns, add blank rows (4 replies)
  2. [SOLVED:] Combine duplicate records and delete (3 replies)
  3. [SOLVED:] Use of Static Statement (9 replies)
  4. [SOLVED:] Using EOMONTH in code with Excel 2000 (7 replies)
  5. Sleeper: Pivot table (0 replies)
  6. Sleeper: Com addin (7 replies)
  7. Sleeper: Spliting of data inside each sheet (2 replies)
  8. [SOLVED:] Dynamic Arrays Question (2 replies)
  9. Sleeper: Searching, Autofilter, Double Input (2 replies)
  10. Sleeper: Threading in VBA (6 replies)
  11. Sleeper: Serial Port and Timer (sleep or delay) (4 replies)
  12. [SOLVED:] Check Box (6 replies)
  13. [SOLVED:] Windows search (7 replies)
  14. [SOLVED:] Using a closed Workbook file (3 replies)
  15. [SOLVED:] Stay in TextBox - UserForm (12 replies)
  16. [SOLVED:] UserForm and Adding up columns (9 replies)
  17. [SOLVED:] Data Validation (4 replies)
  18. [SOLVED:] Display decimal values in a text box (4 replies)
  19. [SOLVED:] How to Clear an Array (4 replies)
  20. [SOLVED:] VBA Coding Help (3 replies)
  21. [SOLVED:] CutCopyMode ... How Is It Used?? (3 replies)
  22. [SOLVED:] "OpenClipboard" Syntax (2 replies)
  23. Sleeper: Inserting Excel OLE Object (1 replies)
  24. Sleeper: Problem with sheet search (2 replies)
  25. [SOLVED:] If formula (6 replies)
  26. Dynamic Range and Pivot problem (13 replies)
  27. [SOLVED:] Assistance with finding the last value (3 replies)
  28. [SOLVED:] Datalabels not appearing on chart (4 replies)
  29. [SOLVED:] How do you make range A sheet 2 equal rangeB sheet 1?? (0 replies)
  30. Sleeper: Error: Push Excel Named Range Values to Bookmarks in Word (3 replies)
  31. Sleeper: Need formula help (9 replies)
  32. Sleeper: Inserting (not entire) rows after groups (excel 97) (10 replies)
  33. Sleeper: Javascript pop-ups/Web Queries (0 replies)
  34. Sleeper: Copy paste transpose multiple sheets onto one sheet (3 replies)
  35. [SOLVED:] How to Recover Columns That Are Off the Sheet (5 replies)
  36. Sleeper: Protected sheets and Links? (3 replies)
  37. [SOLVED:] Referencing Columns in loop (5 replies)
  38. Sleeper: Locking project after importing (2 replies)
  39. Sleeper: Using "Autofit" for merged cells (2 replies)
  40. [SOLVED:] Characters limit in Excel's Cells (2 replies)
  41. [SOLVED:] Bogus Dates (7 replies)
  42. [SOLVED:] In Macro - Clear Clipboard / Free up Memory (6 replies)
  43. [SOLVED:] Change color of background in MultiPage Control for UserForms (3 replies)
  44. Sleeper: Last Row in closed workbook (5 replies)
  45. [SOLVED:] Sort of an Excel calendar (6 replies)
  46. Sleeper: Checkboxes on worksheet (3 replies)
  47. [SOLVED:] Command Button to save & close workbook (3 replies)
  48. Sleeper: Search sheet (7 replies)
  49. Sleeper: Cell to reference sheet tabs in code. (3 replies)
  50. Sleeper: Using the sheet tabs as my validation list (2 replies)
  51. [SOLVED:] Link Excel files with color (10 replies)
  52. [SOLVED:] Multi line MsgBox (4 replies)
  53. Sleeper: Comparing arrays (6 replies)
  54. Sleeper: Managing Comments (5 replies)
  55. Sleeper: Reset of Auto-Filter (13 replies)
  56. Sleeper: Auto-copy if 'Yes' (2 replies)
  57. [SOLVED:] Merging cells problem (3 replies)
  58. [SOLVED:] Show Consecutive Entries.. (3 replies)
  59. [SOLVED:] Help with a range (3 replies)
  60. Sleeper: VBA PasteSpecial (xlAll) pastes picture not data (0 replies)
  61. [SOLVED:] Save with file name issue (4 replies)
  62. Sleeper: Paste not available due to Application event. (3 replies)
  63. [SOLVED:] Sort and insert blank row after groups (Excel97) (6 replies)
  64. Sleeper: IsUDF Function (22 replies)
  65. [SOLVED:] Strange Results From A Prompt (4 replies)
  66. Sleeper: Worksheet Protection (1 replies)
  67. [SOLVED:] Show Definitions of Named Styles (3 replies)
  68. Advice: Extending Rows and Columns (1 replies)
  69. [SOLVED:] Comparing part of a Cell volume against a range (8 replies)
  70. Sleeper: Logging of search results (7 replies)
  71. [SOLVED:] Unable to edit cells in excel (5 replies)
  72. [SOLVED:] Textbox Data (3 replies)
  73. Sleeper: Preventing comments (14 replies)
  74. [SOLVED:] Using If Then Else statement I think? (4 replies)
  75. [SOLVED:] Creating userforms help (10 replies)
  76. Sleeper: Current page method of pivot field failed (3 replies)
  77. Sleeper: Minimizing code (11 replies)
  78. Sleeper: Print VBA Userfrom for a Excel Workbook??? (1 replies)
  79. [SOLVED:] Do something when specific cell selected (10 replies)
  80. [SOLVED:] Button to hide/unhide all empty rows? (Excel 97) (15 replies)
  81. Sleeper: IsError (3 replies)
  82. Sleeper: Filling in website forms (1 replies)
  83. [SOLVED:] If Statement (12 replies)
  84. Sleeper: Worksheet accessing (5 replies)
  85. Sleeper: Quantity Limit on Copying Sheets (2 replies)
  86. Sleeper: Problem while running protected macro (5 replies)
  87. [SOLVED:] Variable Help (3 replies)
  88. [SOLVED:] This should be easy (6 replies)
  89. [SOLVED:] Assigning data from a range to a combobox (9 replies)
  90. Sleeper: A few questions (22 replies)
  91. Sleeper: Creating custom event (1 replies)
  92. Sleeper: Saveas dialog (7 replies)
  93. [SOLVED:] VBA Book recommendation (15 replies)
  94. Sleeper: Override Outlook Do you want to send option (1 replies)
  95. Sleeper: Allow autofilter on protected worksheet (11 replies)
  96. [SOLVED:] Border Row Macro problem (2 replies)
  97. [SOLVED:] Vlookup (9 replies)
  98. [SOLVED:] opening a password protected file using a macro (3 replies)
  99. [SOLVED:] Back-up / Different Paths (10 replies)
  100. [SOLVED:] Need Scheduler General Solution (2 replies)
  101. [SOLVED:] SaveAs Help (3 replies)
  102. Sleeper: Password to update links (5 replies)
  103. [SOLVED:] Bypass "Disable Macros" option (3 replies)
  104. Sleeper: Help working with ranges doing text comparisons (10 replies)
  105. [SOLVED:] Do Loop and Merge Texts (14 replies)
  106. Sleeper: Help needed with VLOOKUP (5 replies)
  107. [SOLVED:] Global Templates (7 replies)
  108. Sleeper: Selecting rows in between 2 speicific words (1 replies)
  109. Sleeper: Getting error in SQL (4 replies)
  110. [SOLVED:] Protecting cells (8 replies)
  111. [SOLVED:] Chartobject appears with 30+series already plotted (6 replies)
  112. [SOLVED:] Conditional formatting (9 replies)
  113. Sleeper: Compare parts of a spreadsheet (8 replies)
  114. [SOLVED:] AddIn Installation (13 replies)
  115. [SOLVED:] 'Application.Volatile True' question (1 replies)
  116. [SOLVED:] Can't Find a Link to Personal.xls (2 replies)
  117. Macros Assigned to AutoShapes (3 replies)
  118. Sleeper: Filter Problems (3 replies)
  119. [SOLVED:] Problem whit a macro (10 replies)
  120. [SOLVED:] Function tweak (21 replies)
  121. Sleeper: VBA array questions...BIG project (3 replies)
  122. Sleeper: Link Excel to pdf (2 replies)
  123. [SOLVED:] Order alphabetically (11 replies)
  124. [SOLVED:] Edit sheetname (3 replies)
  125. Sleeper: Form Date (7 replies)
  126. [SOLVED:] Type Mismatch error (16 replies)
  127. [SOLVED:] Command button attached to Text box (4 replies)
  128. Sleeper: Choosing formula in combobox (2 replies)
  129. [SOLVED:] Inconsistent Function Return (4 replies)
  130. [SOLVED:] Find Method Question (2 replies)
  131. [SOLVED:] Protect worksheet tab name (11 replies)
  132. [SOLVED:] Auto Save With Date (3 replies)
  133. [SOLVED:] Copy selected column in listbox to a new worksheet (2 replies)
  134. [SOLVED:] Extract numbers from texts and do substraction (12 replies)
  135. [SOLVED:] Can an event macro be called? (22 replies)
  136. [SOLVED:] Copy a formula on a worksheet by the number of data rows on a different sheet (2 replies)
  137. [SOLVED:] Excel Password to modify in Macro... (2 replies)
  138. [SOLVED:] Coding Error :( (3 replies)
  139. [SOLVED:] Formula to return monday of current week (13 replies)
  140. Solved: Wrapping text question (4 replies)
  141. [SOLVED:] statistical function using VBA (4 replies)
  142. [SOLVED:] Delete empty rows (5 replies)
  143. [SOLVED:] Converting Text to Worksheet Hyperlink (6 replies)
  144. Solved: Vlookup with Multiple Returns (7 replies)
  145. Sleeper: Sending email via Lotus Notes (3 replies)
  146. [SOLVED:] VBA to Identify Negative Balances (9 replies)
  147. Sleeper: Setting print settings in VBA (7 replies)
  148. Sleeper: Lotus Notes view to excel sheet (3 replies)
  149. [SOLVED:] turn formula to a vba function (1 replies)
  150. Sleeper: Comment position (10 replies)
  151. [SOLVED:] Another border question... (7 replies)
  152. [SOLVED:] Save charts of a workbook into another new workbook (16 replies)
  153. [SOLVED:] Function acting funny (3 replies)
  154. [SOLVED:] Problem: Generate sequences (10 replies)
  155. [SOLVED:] Control the command button (10 replies)
  156. [SOLVED:] Help with value from userform (8 replies)
  157. [SOLVED:] Disable Enable/Disable Macro window (7 replies)
  158. [SOLVED:] Help with border macro (6 replies)
  159. [SOLVED:] Delete Userform Picture (2 replies)
  160. [SOLVED:] If Statement (7 replies)
  161. [SOLVED:] Using yields from another ss (31 replies)
  162. [SOLVED:] With Statement with multiple arguments (6 replies)
  163. [SOLVED:] Excel's Status Bar (7 replies)
  164. [SOLVED:] Find two minumum values from a range (14 replies)
  165. [SOLVED:] Warning if quarterly forecasts exceed annual budget (20 replies)
  166. [SOLVED:] ElseIf..nightmare! (14 replies)
  167. Sleeper: Drop down list to activate sheet? (9 replies)
  168. Sleeper: Initialize a UserForm (2 replies)
  169. Sleeper: Picking up the speed? (2 replies)
  170. [SOLVED:] Combine sheets (3 replies)
  171. [SOLVED:] Is it possible to code this !!!! (6 replies)
  172. Sleeper: Trace User changes/force save via VBA (11 replies)
  173. [SOLVED:] Auto Sort a Worksheet when selected (2 replies)
  174. Sleeper: Importing selected data from 3 html tables (2 replies)
  175. Sleeper: Userform pop-up when inserting a comment (6 replies)
  176. [SOLVED:] Macro to get HD info or computer name? (4 replies)
  177. [SOLVED:] Need Help writing a Macro for a Bill of Material (13 replies)
  178. strange characters input from text file (20 replies)
  179. Sleeper: Display clipboard contents (2 replies)
  180. [SOLVED:] Popup blocking my Progress (8 replies)
  181. [SOLVED:] Help with "Get File List" Macro (6 replies)
  182. Sleeper: Can't run second times in VB code! (10 replies)
  183. [SOLVED:] What's the syntax for adding colour? (8 replies)
  184. Sleeper: Calculate lookup table (1 replies)
  185. [SOLVED:] How to create xla for Excel from outside (13 replies)
  186. [SOLVED:] Dealing with different workbooks (12 replies)
  187. Sleeper: Macro from Sub to Function question (34 replies)
  188. [SOLVED:] Macro's that open files with passwords (3 replies)
  189. [SOLVED:] Show or hide images, according to the value of a cell (22 replies)
  190. [SLEEPER:] Working on a range (4 replies)
  191. Sleeper: File Size warning (5 replies)
  192. [SOLVED:] Get value and color of cells with Access (2 replies)
  193. Sleeper: How to make weighted average in pivot tables (4 replies)
  194. comparing spreadsheet (1 replies)
  195. [SOLVED:] Data persistence without using sheet or external file (14 replies)
  196. Dependant Combo Boxes (19 replies)
  197. Sleeper: Doing Time..... (11 replies)
  198. [SOLVED:] Problem with Range Box (3 replies)
  199. [SOLVED:] Counting Blank Cells (6 replies)
  200. [SOLVED:] Multi-line range name assignments? (16 replies)
  201. Sleeper: If statements and Chart Series (1 replies)
  202. [SOLVED:] Running a macro in another workbook (3 replies)
  203. Sleeper: Export table to Word (1 replies)
  204. [SOLVED:] Code Help (20 replies)
  205. [SOLVED:] Copy worksheets (3 replies)
  206. [SOLVED:] Enter Key activates Command Button (3 replies)
  207. [SOLVED:] Disable Macros (2 replies)
  208. [SOLVED:] Making an ActiveX control button inactive? (5 replies)
  209. Sleeper: Convert Array Formula to VBA (14 replies)
  210. [SOLVED:] Make Code work on 3 columns instead of just one. (4 replies)
  211. Sleeper: Allow users to edit range - problem (9 replies)
  212. Sleeper: Copy cell down (9 replies)
  213. [SOLVED:] Action on every sheet (10 replies)
  214. prime numbers (12 replies)
  215. Sleeper: Macro to Open workbook and Update Links Automatically (Solved) (3 replies)
  216. Sleeper: Macro to email file through Lotus Notes (Solved) (1 replies)
  217. [SOLVED:] Macros to Protect/Unprotect Worksheets and Workbooks (2 replies)
  218. [SOLVED:] Separate and Hyperlink to proper position of data (2 replies)
  219. [SOLVED:] Fade a splash screen (15 replies)
  220. [SOLVED:] Return values from formula range (4 replies)
  221. Sleeper: Toggle between two worksheets (4 replies)
  222. [SOLVED:] How do I declare a module wide date that is in the form of say (3rd wednesday of the (2 replies)
  223. [SOLVED:] Help with syntax to Run code in one XLS from another XLS (6 replies)
  224. [SOLVED:] User defined name (not linked to cell) (2 replies)
  225. [SOLVED:] Is there a way after macro runs to email............. (5 replies)
  226. Sleeper: Unhide worksheet based on cell value (1 replies)
  227. Sleeper: Macro for Segregation of Text & Numer from range (6 replies)
  228. Sleeper: Encrypting VBA Code - Third party tools? (3 replies)
  229. [SOLVED:] Excel.exe has generated errors????? (12 replies)
  230. [SOLVED:] Naming AutoShapes - Bad Idea?? (6 replies)
  231. Message Box trouble (8 replies)
  232. [SOLVED:] Counting blank cells with formulas in them (9 replies)
  233. [SOLVED:] Toggle optionbutton (from forms) (11 replies)
  234. [SOLVED:] Copy, Paste and Transpose (14 replies)
  235. [SOLVED:] Create desktop shortcut (5 replies)
  236. Solved: Excessive Windows in VBE (9 replies)
  237. Sleeper: Excel and Microsoft Office Document Image Writer (1 replies)
  238. [SOLVED:] How to use VBA to write a bat file and execute it? (17 replies)
  239. Sleeper: Disable CellDragAndDrop for FillRight AND FillLeft (5 replies)
  240. [SOLVED:] Import data from a web page to Excel (2 replies)
  241. Sleeper: Delete a macro (2 replies)
  242. [SOLVED:] How to make the range only as long as needs to be ... (10 replies)
  243. [SOLVED:] Fill a list box with unique items (18 replies)
  244. Sleeper: Message Box Help (5 replies)
  245. [SOLVED:] Sheet names (7 replies)
  246. [SOLVED:] How associate a number to a day of the Week (13 replies)
  247. [SOLVED:] Can VBA codes call a bat file? (4 replies)
  248. [SOLVED:] Move focus to CommandButton (6 replies)
  249. [SOLVED:] Search and delete record, using macros (4 replies)
  250. [SOLVED:] Making "Things" on Charts Move With Charts (3 replies)