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:] Bypass "Disable Macros" option (3 replies)
  2. Sleeper: Help working with ranges doing text comparisons (10 replies)
  3. [SOLVED:] Do Loop and Merge Texts (14 replies)
  4. Sleeper: Help needed with VLOOKUP (5 replies)
  5. [SOLVED:] Global Templates (7 replies)
  6. Sleeper: Selecting rows in between 2 speicific words (1 replies)
  7. Sleeper: Getting error in SQL (4 replies)
  8. [SOLVED:] Protecting cells (8 replies)
  9. [SOLVED:] Chartobject appears with 30+series already plotted (6 replies)
  10. [SOLVED:] Conditional formatting (9 replies)
  11. Sleeper: Compare parts of a spreadsheet (8 replies)
  12. [SOLVED:] AddIn Installation (13 replies)
  13. [SOLVED:] 'Application.Volatile True' question (1 replies)
  14. [SOLVED:] Can't Find a Link to Personal.xls (2 replies)
  15. Macros Assigned to AutoShapes (3 replies)
  16. Sleeper: Filter Problems (3 replies)
  17. [SOLVED:] Problem whit a macro (10 replies)
  18. [SOLVED:] Function tweak (21 replies)
  19. Sleeper: VBA array questions...BIG project (3 replies)
  20. Sleeper: Link Excel to pdf (2 replies)
  21. [SOLVED:] Order alphabetically (11 replies)
  22. [SOLVED:] Edit sheetname (3 replies)
  23. Sleeper: Form Date (7 replies)
  24. [SOLVED:] Type Mismatch error (16 replies)
  25. [SOLVED:] Command button attached to Text box (4 replies)
  26. Sleeper: Choosing formula in combobox (2 replies)
  27. [SOLVED:] Inconsistent Function Return (4 replies)
  28. [SOLVED:] Find Method Question (2 replies)
  29. [SOLVED:] Protect worksheet tab name (11 replies)
  30. [SOLVED:] Auto Save With Date (3 replies)
  31. [SOLVED:] Copy selected column in listbox to a new worksheet (2 replies)
  32. [SOLVED:] Extract numbers from texts and do substraction (12 replies)
  33. [SOLVED:] Can an event macro be called? (22 replies)
  34. [SOLVED:] Copy a formula on a worksheet by the number of data rows on a different sheet (2 replies)
  35. [SOLVED:] Excel Password to modify in Macro... (2 replies)
  36. [SOLVED:] Coding Error :( (3 replies)
  37. [SOLVED:] Formula to return monday of current week (13 replies)
  38. Solved: Wrapping text question (4 replies)
  39. [SOLVED:] statistical function using VBA (4 replies)
  40. [SOLVED:] Delete empty rows (5 replies)
  41. [SOLVED:] Converting Text to Worksheet Hyperlink (6 replies)
  42. Solved: Vlookup with Multiple Returns (7 replies)
  43. Sleeper: Sending email via Lotus Notes (3 replies)
  44. [SOLVED:] VBA to Identify Negative Balances (9 replies)
  45. [SLEEPER:] Setting print settings in VBA (7 replies)
  46. Sleeper: Lotus Notes view to excel sheet (3 replies)
  47. [SOLVED:] turn formula to a vba function (1 replies)
  48. Sleeper: Comment position (10 replies)
  49. [SOLVED:] Another border question... (7 replies)
  50. [SOLVED:] Save charts of a workbook into another new workbook (16 replies)
  51. [SOLVED:] Function acting funny (3 replies)
  52. [SOLVED:] Problem: Generate sequences (10 replies)
  53. [SOLVED:] Control the command button (10 replies)
  54. [SOLVED:] Help with value from userform (8 replies)
  55. [SOLVED:] Disable Enable/Disable Macro window (7 replies)
  56. [SOLVED:] Help with border macro (6 replies)
  57. [SOLVED:] Delete Userform Picture (2 replies)
  58. [SOLVED:] If Statement (7 replies)
  59. [SOLVED:] Using yields from another ss (31 replies)
  60. [SOLVED:] With Statement with multiple arguments (6 replies)
  61. [SOLVED:] Excel's Status Bar (7 replies)
  62. [SOLVED:] Find two minumum values from a range (14 replies)
  63. [SOLVED:] Warning if quarterly forecasts exceed annual budget (20 replies)
  64. [SOLVED:] ElseIf..nightmare! (14 replies)
  65. Sleeper: Drop down list to activate sheet? (9 replies)
  66. Sleeper: Initialize a UserForm (2 replies)
  67. Sleeper: Picking up the speed? (2 replies)
  68. [SOLVED:] Combine sheets (3 replies)
  69. [SOLVED:] Is it possible to code this !!!! (6 replies)
  70. Sleeper: Trace User changes/force save via VBA (11 replies)
  71. [SOLVED:] Auto Sort a Worksheet when selected (2 replies)
  72. Sleeper: Importing selected data from 3 html tables (2 replies)
  73. Sleeper: Userform pop-up when inserting a comment (6 replies)
  74. [SOLVED:] Macro to get HD info or computer name? (4 replies)
  75. [SOLVED:] Need Help writing a Macro for a Bill of Material (13 replies)
  76. strange characters input from text file (20 replies)
  77. Sleeper: Display clipboard contents (2 replies)
  78. [SOLVED:] Popup blocking my Progress (8 replies)
  79. [SOLVED:] Help with "Get File List" Macro (6 replies)
  80. Sleeper: Can't run second times in VB code! (10 replies)
  81. [SOLVED:] What's the syntax for adding colour? (8 replies)
  82. Sleeper: Calculate lookup table (1 replies)
  83. [SOLVED:] How to create xla for Excel from outside (13 replies)
  84. [SOLVED:] Dealing with different workbooks (12 replies)
  85. Sleeper: Macro from Sub to Function question (34 replies)
  86. [SOLVED:] Macro's that open files with passwords (3 replies)
  87. [SOLVED:] Show or hide images, according to the value of a cell (22 replies)
  88. [SLEEPER:] Working on a range (4 replies)
  89. Sleeper: File Size warning (5 replies)
  90. [SOLVED:] Get value and color of cells with Access (2 replies)
  91. Sleeper: How to make weighted average in pivot tables (4 replies)
  92. comparing spreadsheet (1 replies)
  93. [SOLVED:] Data persistence without using sheet or external file (14 replies)
  94. Dependant Combo Boxes (19 replies)
  95. Sleeper: Doing Time..... (11 replies)
  96. [SOLVED:] Problem with Range Box (3 replies)
  97. [SOLVED:] Counting Blank Cells (6 replies)
  98. [SOLVED:] Multi-line range name assignments? (16 replies)
  99. Sleeper: If statements and Chart Series (1 replies)
  100. [SOLVED:] Running a macro in another workbook (3 replies)
  101. Sleeper: Export table to Word (1 replies)
  102. [SOLVED:] Code Help (20 replies)
  103. [SOLVED:] Copy worksheets (3 replies)
  104. [SOLVED:] Enter Key activates Command Button (3 replies)
  105. [SOLVED:] Disable Macros (2 replies)
  106. [SOLVED:] Making an ActiveX control button inactive? (5 replies)
  107. [SOLVED:] Convert Array Formula to VBA (14 replies)
  108. [SOLVED:] Make Code work on 3 columns instead of just one. (4 replies)
  109. Sleeper: Allow users to edit range - problem (9 replies)
  110. Sleeper: Copy cell down (9 replies)
  111. [SOLVED:] Action on every sheet (10 replies)
  112. prime numbers (12 replies)
  113. Sleeper: Macro to Open workbook and Update Links Automatically (Solved) (3 replies)
  114. Sleeper: Macro to email file through Lotus Notes (Solved) (1 replies)
  115. [SOLVED:] Macros to Protect/Unprotect Worksheets and Workbooks (2 replies)
  116. [SOLVED:] Separate and Hyperlink to proper position of data (2 replies)
  117. [SOLVED:] Fade a splash screen (15 replies)
  118. [SOLVED:] Return values from formula range (4 replies)
  119. Sleeper: Toggle between two worksheets (4 replies)
  120. [SOLVED:] How do I declare a module wide date that is in the form of say (3rd wednesday of the (2 replies)
  121. [SOLVED:] Help with syntax to Run code in one XLS from another XLS (6 replies)
  122. [SOLVED:] User defined name (not linked to cell) (2 replies)
  123. [SOLVED:] Is there a way after macro runs to email............. (5 replies)
  124. Sleeper: Unhide worksheet based on cell value (1 replies)
  125. Sleeper: Macro for Segregation of Text & Numer from range (6 replies)
  126. Sleeper: Encrypting VBA Code - Third party tools? (3 replies)
  127. [SOLVED:] Excel.exe has generated errors????? (12 replies)
  128. [SOLVED:] Naming AutoShapes - Bad Idea?? (6 replies)
  129. Message Box trouble (8 replies)
  130. [SOLVED:] Counting blank cells with formulas in them (9 replies)
  131. [SOLVED:] Toggle optionbutton (from forms) (11 replies)
  132. [SOLVED:] Copy, Paste and Transpose (14 replies)
  133. [SOLVED:] Create desktop shortcut (5 replies)
  134. Solved: Excessive Windows in VBE (9 replies)
  135. Sleeper: Excel and Microsoft Office Document Image Writer (1 replies)
  136. [SOLVED:] How to use VBA to write a bat file and execute it? (17 replies)
  137. Sleeper: Disable CellDragAndDrop for FillRight AND FillLeft (5 replies)
  138. [SOLVED:] Import data from a web page to Excel (2 replies)
  139. Sleeper: Delete a macro (2 replies)
  140. [SOLVED:] How to make the range only as long as needs to be ... (10 replies)
  141. [SOLVED:] Fill a list box with unique items (18 replies)
  142. Sleeper: Message Box Help (5 replies)
  143. [SOLVED:] Sheet names (7 replies)
  144. [SOLVED:] How associate a number to a day of the Week (13 replies)
  145. [SOLVED:] Can VBA codes call a bat file? (4 replies)
  146. [SOLVED:] Move focus to CommandButton (6 replies)
  147. [SOLVED:] Search and delete record, using macros (4 replies)
  148. [SOLVED:] Making "Things" on Charts Move With Charts (3 replies)
  149. Sleeper: Change interior color based on a check box (5 replies)
  150. Sleeper: Selecting visible cells. (2 replies)
  151. Sleeper: Select range (7 replies)
  152. Sleeper: Dodge-Ball-Team Sorting System (7 replies)
  153. [SOLVED:] Does a path exist? (10 replies)
  154. [SOLVED:] Copy from one sheet to another? (6 replies)
  155. Sleeper: Problem setting the Print Area (3 replies)
  156. Sleeper: Help to select date range w/ count (9 replies)
  157. [SOLVED:] Date set to kill a ws (9 replies)
  158. Sleeper: Numberformat, in^3 vs in? (1 replies)
  159. [SOLVED:] Addling to a multi column listbox with VBA (3 replies)
  160. Sleeper: Merge styles (1 replies)
  161. Sleeper: Cell Annotation - Formula to viewable updating text (2 replies)
  162. [SOLVED:] Value from another workbook (2 replies)
  163. [SLEEPER:] Function for BOLD format (4 replies)
  164. [SOLVED:] Divide texts into column (10 replies)
  165. [SOLVED:] If statement (11 replies)
  166. [SOLVED:] Formula Array in VBA (6 replies)
  167. [SOLVED:] Check Windows version (8 replies)
  168. [SOLVED:] Counting and summing occurrence (12 replies)
  169. Sleeper: How to activate an open workbook (10 replies)
  170. [SOLVED:] Segregation of Numerical & Text data (8 replies)
  171. Advice: Google Desktop not compatible with Excel (2 replies)
  172. [SOLVED:] Help with date macro (7 replies)
  173. [SOLVED:] Macro to print multiple non-adjacent area in a worksheet. (5 replies)
  174. Sleeper: Validate a Date!?? (3 replies)
  175. [SOLVED:] Pasting formulas into a dynamic range (3 replies)
  176. [SOLVED:] Difference between Auto Open and Workbook Open (2 replies)
  177. [SOLVED:] Input Box (6 replies)
  178. [SOLVED:] Hide & protect sheet (17 replies)
  179. [SOLVED:] Range with a variable (2 replies)
  180. [SOLVED:] Usage Of Array function (5 replies)
  181. [SOLVED:] Format a value (2 replies)
  182. Sleeper: Select uneven columns (1 replies)
  183. Sleeper: Updating data in a spreadsheet with User Form? (12 replies)
  184. [SOLVED:] Replace Formats (3 replies)
  185. Sleeper: VBA Code error for If then else. (5 replies)
  186. [SOLVED:] Strange Errors/Breaks (3 replies)
  187. Solved: MISSING: Microsoft ActiveX Data Objects Record 2.8 Library (7 replies)
  188. [SOLVED:] Amortization calculator (1 replies)
  189. Sleeper: Open files in a folder one at a time (7 replies)
  190. Sleeper: Open Excel Workbook as read Only (2 replies)
  191. Sleeper: Ctr + Z after running macro (7 replies)
  192. [SOLVED:] Text Case Conversion Procedure "Proper Case" for Excel (6 replies)
  193. [SOLVED:] Sharing variables between forms and modules (2 replies)
  194. Sleeper: Text problem (8 replies)
  195. [SOLVED:] Code to Sort, Replace and Count results (15 replies)
  196. [SOLVED:] Text box to return cell value from other sheet (3 replies)
  197. [SOLVED:] Excel Conditional Formatting with a formula (2 replies)
  198. [SOLVED:] Macro to check dates and notify user (8 replies)
  199. [SOLVED:] Macro wont run except... (5 replies)
  200. [SOLVED:] Referencing cell through constant problem (3 replies)
  201. Sleeper: Windows Registry (21 replies)
  202. Sleeper: @ mdmackillop..need further help on previous request. (3 replies)
  203. [SOLVED:] Customising Right Click (4 replies)
  204. Sleeper: How to Package Addin File for Excel (8 replies)
  205. [SOLVED:] Compile error message (11 replies)
  206. [SOLVED:] Hyperlink query (8 replies)
  207. [SOLVED:] Adding comments (1 replies)
  208. [SOLVED:] Advice on adding a row (13 replies)
  209. [SOLVED:] Unprotect and protect after macro run (7 replies)
  210. [SOLVED:] Find (11 replies)
  211. [SOLVED:] Go back to cell (4 replies)
  212. Sleeper: Date/Time picker control (2 replies)
  213. Sleeper: Automatically set merged cell height (3 replies)
  214. [SOLVED:] Error after running code (2 replies)
  215. Sleeper: Lock the screen (8 replies)
  216. Sleeper: Transferring date and text data to an excel file (2 replies)
  217. [SOLVED:] Sleeper: Using combo box in excel (10 replies)
  218. [SOLVED:] ISBLANK problem (5 replies)
  219. [SOLVED:] how to startup excel with a form (3 replies)
  220. [SOLVED:] Excel Properties (13 replies)
  221. Open Lotus 123 Files and save as Excel (8 replies)
  222. Sleeper: Compare and Calculate the Sum (14 replies)
  223. [SOLVED:] Run Marco by click on a cell (1 replies)
  224. Sleeper: Find in UDF (2 replies)
  225. [SLEEPER:] Need help with Macro's and Userforms. :) (2 replies)
  226. [SOLVED:] Cell looses format after number from User Form is placed in it. (6 replies)
  227. Solved: Delete The File Itself (16 replies)
  228. Sleeper: Autofilter Problem (1 replies)
  229. Sleeper: Moving upward (3 replies)
  230. [SOLVED:] VBA SaveAs xlTextMSDos creates (sometimes) quote marks (2 replies)
  231. Sleeper: Excel to CSV bug (3 replies)
  232. [SOLVED:] Overflow Problem (1 replies)
  233. Sleeper: Dodge-ball Team Sorting System (4 replies)
  234. [SOLVED:] A Matching Problem (2 replies)
  235. Sleeper: Trouble with Refreshing Pivot Table w/ Remote Data (0 replies)
  236. [SOLVED:] Excel VBA to change properties of non-Excel file (3 replies)
  237. [SOLVED:] Formatting help (3 replies)
  238. [SOLVED:] Autoshape Automation (20 replies)
  239. Sleeper: Country settings changed via vba (2 replies)
  240. [SOLVED:] UserForm Image (3 replies)
  241. [SOLVED:] Number format (28 replies)
  242. Sleeper: Switch Form (4 replies)
  243. [SOLVED:] Counting Used Cells in a Range (4 replies)
  244. Sleeper: Copy vba macros (1 replies)
  245. [SOLVED:] Delete all txt files within a Folder (12 replies)
  246. [SOLVED:] Query on selection.column (2 replies)
  247. [SOLVED:] Select entire row excep cells in merged area (4 replies)
  248. [SOLVED:] Flexible copy-to range (2 replies)
  249. [SOLVED:] Error msg: File is already opened (13 replies)
  250. Sleeper: Open closed excel file (2 replies)