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: Change interior color based on a check box (5 replies)
  2. Sleeper: Selecting visible cells. (2 replies)
  3. Sleeper: Select range (7 replies)
  4. Sleeper: Dodge-Ball-Team Sorting System (7 replies)
  5. [SOLVED:] Does a path exist? (10 replies)
  6. [SOLVED:] Copy from one sheet to another? (6 replies)
  7. Sleeper: Problem setting the Print Area (3 replies)
  8. Sleeper: Help to select date range w/ count (9 replies)
  9. [SOLVED:] Date set to kill a ws (9 replies)
  10. Sleeper: Numberformat, in^3 vs in? (1 replies)
  11. [SOLVED:] Addling to a multi column listbox with VBA (3 replies)
  12. Sleeper: Merge styles (1 replies)
  13. Sleeper: Cell Annotation - Formula to viewable updating text (2 replies)
  14. [SOLVED:] Value from another workbook (2 replies)
  15. Sleeper: Function for BOLD format (4 replies)
  16. [SOLVED:] Divide texts into column (10 replies)
  17. [SOLVED:] If statement (11 replies)
  18. [SOLVED:] Formula Array in VBA (6 replies)
  19. [SOLVED:] Check Windows version (8 replies)
  20. [SOLVED:] Counting and summing occurrence (12 replies)
  21. Sleeper: How to activate an open workbook (10 replies)
  22. [SOLVED:] Segregation of Numerical & Text data (8 replies)
  23. Advice: Google Desktop not compatible with Excel (2 replies)
  24. [SOLVED:] Help with date macro (7 replies)
  25. [SOLVED:] Macro to print multiple non-adjacent area in a worksheet. (5 replies)
  26. Sleeper: Validate a Date!?? (3 replies)
  27. [SOLVED:] Pasting formulas into a dynamic range (3 replies)
  28. [SOLVED:] Difference between Auto Open and Workbook Open (2 replies)
  29. [SOLVED:] Input Box (6 replies)
  30. [SOLVED:] Hide & protect sheet (17 replies)
  31. [SOLVED:] Range with a variable (2 replies)
  32. [SOLVED:] Usage Of Array function (5 replies)
  33. [SOLVED:] Format a value (2 replies)
  34. Sleeper: Select uneven columns (1 replies)
  35. Sleeper: Updating data in a spreadsheet with User Form? (12 replies)
  36. [SOLVED:] Replace Formats (3 replies)
  37. Sleeper: VBA Code error for If then else. (5 replies)
  38. [SOLVED:] Strange Errors/Breaks (3 replies)
  39. Solved: MISSING: Microsoft ActiveX Data Objects Record 2.8 Library (7 replies)
  40. [SOLVED:] Amortization calculator (1 replies)
  41. Sleeper: Open files in a folder one at a time (7 replies)
  42. Sleeper: Open Excel Workbook as read Only (2 replies)
  43. Sleeper: Ctr + Z after running macro (7 replies)
  44. [SOLVED:] Text Case Conversion Procedure "Proper Case" for Excel (6 replies)
  45. [SOLVED:] Sharing variables between forms and modules (2 replies)
  46. Sleeper: Text problem (8 replies)
  47. [SOLVED:] Code to Sort, Replace and Count results (15 replies)
  48. [SOLVED:] Text box to return cell value from other sheet (3 replies)
  49. [SOLVED:] Excel Conditional Formatting with a formula (2 replies)
  50. [SOLVED:] Macro to check dates and notify user (8 replies)
  51. [SOLVED:] Macro wont run except... (5 replies)
  52. [SOLVED:] Referencing cell through constant problem (3 replies)
  53. Sleeper: Windows Registry (21 replies)
  54. Sleeper: @ mdmackillop..need further help on previous request. (3 replies)
  55. [SOLVED:] Customising Right Click (4 replies)
  56. Sleeper: How to Package Addin File for Excel (8 replies)
  57. [SOLVED:] Compile error message (11 replies)
  58. [SOLVED:] Hyperlink query (8 replies)
  59. [SOLVED:] Adding comments (1 replies)
  60. [SOLVED:] Advice on adding a row (13 replies)
  61. [SOLVED:] Unprotect and protect after macro run (7 replies)
  62. [SOLVED:] Find (11 replies)
  63. [SOLVED:] Go back to cell (4 replies)
  64. Sleeper: Date/Time picker control (2 replies)
  65. Sleeper: Automatically set merged cell height (3 replies)
  66. [SOLVED:] Error after running code (2 replies)
  67. Sleeper: Lock the screen (8 replies)
  68. Sleeper: Transferring date and text data to an excel file (2 replies)
  69. [SOLVED:] Sleeper: Using combo box in excel (10 replies)
  70. [SOLVED:] ISBLANK problem (5 replies)
  71. [SOLVED:] how to startup excel with a form (3 replies)
  72. [SOLVED:] Excel Properties (13 replies)
  73. Open Lotus 123 Files and save as Excel (8 replies)
  74. Sleeper: Compare and Calculate the Sum (14 replies)
  75. [SOLVED:] Run Marco by click on a cell (1 replies)
  76. Sleeper: Find in UDF (2 replies)
  77. [SLEEPER:] Need help with Macro's and Userforms. :) (2 replies)
  78. [SOLVED:] Cell looses format after number from User Form is placed in it. (6 replies)
  79. Solved: Delete The File Itself (16 replies)
  80. Sleeper: Autofilter Problem (1 replies)
  81. Sleeper: Moving upward (3 replies)
  82. [SOLVED:] VBA SaveAs xlTextMSDos creates (sometimes) quote marks (2 replies)
  83. Sleeper: Excel to CSV bug (3 replies)
  84. [SOLVED:] Overflow Problem (1 replies)
  85. Sleeper: Dodge-ball Team Sorting System (4 replies)
  86. Sleeper: A Matching Problem (2 replies)
  87. Sleeper: Trouble with Refreshing Pivot Table w/ Remote Data (0 replies)
  88. [SOLVED:] Excel VBA to change properties of non-Excel file (3 replies)
  89. [SOLVED:] Formatting help (3 replies)
  90. [SOLVED:] Autoshape Automation (20 replies)
  91. Sleeper: Country settings changed via vba (2 replies)
  92. [SOLVED:] UserForm Image (3 replies)
  93. [SOLVED:] Number format (28 replies)
  94. Sleeper: Switch Form (4 replies)
  95. [SOLVED:] Counting Used Cells in a Range (4 replies)
  96. Sleeper: Copy vba macros (1 replies)
  97. [SOLVED:] Delete all txt files within a Folder (12 replies)
  98. [SOLVED:] Query on selection.column (2 replies)
  99. [SOLVED:] Select entire row excep cells in merged area (4 replies)
  100. [SOLVED:] Flexible copy-to range (2 replies)
  101. [SOLVED:] Error msg: File is already opened (13 replies)
  102. Sleeper: Open closed excel file (2 replies)
  103. Solved: IP Address (17 replies)
  104. [SOLVED:] Sorting for Unique records using VBA (3 replies)
  105. Sleeper: Problem with Before_Close code (11 replies)
  106. Sleeper: Running a VB Function From Excel (2 replies)
  107. Sleeper: Help with Status Bar (1 replies)
  108. [SOLVED:] Need help enlarging a range of cells.. (14 replies)
  109. [SOLVED:] MsbBox with vbYesNo determines whether sub should proceed (3 replies)
  110. Sleeper: A sheet tab (4 replies)
  111. [SOLVED:] Prevent msg box when deleting a sheet (2 replies)
  112. Sleeper: Pasting Links Part 2 (1 replies)
  113. [SOLVED:] Macro Help (17 replies)
  114. [SOLVED:] Inserting Time in a cell (12 replies)
  115. [SOLVED:] Check List, Add New Item (20 replies)
  116. Sleeper: Hightlight each different number (1 replies)
  117. [SOLVED:] Vlookup macro not compiling? (4 replies)
  118. [SOLVED:] Resize Comment (4 replies)
  119. [SOLVED:] Error 1004 if we don't want to save (5 replies)
  120. [SOLVED:] Convert % value to text using IF (6 replies)
  121. [SOLVED:] Can I Hypelink to a specific worksheet in another workbook? (8 replies)
  122. [SOLVED:] File List with User customisations? (4 replies)
  123. [SOLVED:] Shut off Microsoft Warning (8 replies)
  124. Sleeper: Have any of you experienced this problem with excel? (4 replies)
  125. Sleeper: Problem downloading data from Web (3 replies)
  126. [SOLVED:] Seprate data with space after every 3 chars (2 replies)
  127. [SOLVED:] Macro to Delete Blank Sheets (4 replies)
  128. Sleeper: Internet Explorer viewing pane in a VBA Form (2 replies)
  129. [SOLVED:] URGENT HELP REQ. (RUN-TIME ERROR) (6 replies)
  130. [SOLVED:] Password in Macro (22 replies)
  131. [SOLVED:] Speeding up macro code (7 replies)
  132. [SOLVED:] Right Click TextBox Menu (14 replies)
  133. [SOLVED:] retrieving cell information from multiple files (8 replies)
  134. [SOLVED:] Get selected range address w/o column name (2 replies)
  135. Sleeper: Used Column Value (8 replies)
  136. [SOLVED:] Autofilter Vs Colorindex (2 replies)
  137. [SOLVED:] Application.GetOpenFilename Dialog Box (3 replies)
  138. [SOLVED:] Dynamic Series problem in Dynamic Chart (4 replies)
  139. Sleeper: Extend Cell Column Width (8 replies)
  140. [SOLVED:] Go To Previous Worksheet / Go To Next Worksheet (11 replies)
  141. [SOLVED:] Cell Reference, No VBA Required (3 replies)
  142. Sleeper:Running Macros from an FTP Server (10 replies)
  143. Sleeper: Run-time error '2147417848 (80010108)' (8 replies)
  144. Sleeper: How to remove a dir which already contains a dir (7 replies)
  145. [SOLVED:] Code Wont' Run in 97 (4 replies)
  146. [SOLVED:] Custom Menus (11 replies)
  147. [SOLVED:] Excel 97 Only Test Machine (7 replies)
  148. Sleeper: How to allow multiple users to update workbook (on network)? (2 replies)
  149. Export Sheet to new Workbook (19 replies)
  150. [SOLVED:] Help with If...Then (3 replies)
  151. [SOLVED:] Security Level Macros - Protecting Workbook (1 replies)
  152. [SOLVED:] Sheeting Permissions (6 replies)
  153. [SOLVED:] Naming a Workbook from a cell (4 replies)
  154. [SOLVED:] Proper case question (5 replies)
  155. [SOLVED:] Pasting Links (5 replies)
  156. [SOLVED:] Remove module from closed workbook (2 replies)
  157. [SOLVED:] Something better than IF(OR (9 replies)
  158. Sleeper: UserForms help (5 replies)
  159. [SOLVED:] Advanced Filter with duplicate deletions (10 replies)
  160. Sleeper: Summing & average by numberformat (3 replies)
  161. [SOLVED:] Freeze Pane (8 replies)
  162. Sleeper: Return a value if the selction is blank (1 replies)
  163. Sleeper: Customize KB Code to Delete Rows (2 replies)
  164. Sleeper: Cell reference for Duplicates (2 replies)
  165. Sleeper: Using VBA to count documents within a folder (3 replies)
  166. [SOLVED:] Fill ascending numbers (5 replies)
  167. [SOLVED:] Summing based on data range (7 replies)
  168. [SOLVED:] increasing strings or adding strings (8 replies)
  169. [SOLVED:] Distinguishing Between FALSE and 0 (8 replies)
  170. Sleeper: Change text to upper case after specified symbols (1 replies)
  171. Sleeper: Concetenate with bold letter for one line (11 replies)
  172. [SOLVED:] Effect of "Else:" (6 replies)
  173. Sleeper: Summing based on numberformat (20 replies)
  174. Sleeper: Export to text files (23 replies)
  175. Sleeper: Macro Code for Save but no Dialog Boxes (5 replies)
  176. [SOLVED:] Copy from one location and split to two locations (4 replies)
  177. Sleeper: Aggregated charts (1 replies)
  178. Hyperlinking to an Adobe PDF file? (1 replies)
  179. Sleeper: Machine configuration for Excel VBA (1 replies)
  180. [SOLVED:] highlighting the last row (1 replies)
  181. Sleeper: Populating Ranges (10 replies)
  182. [SOLVED:] Putting data where you want it!! (3 replies)
  183. [SOLVED:] Excel - how can I fill a column with determinated values? (4 replies)
  184. Sleeper: Load Folder Content in Single Column List Box (40 replies)
  185. Sleeper: FEM Solution using Excel/VBA (2 replies)
  186. Sleeper: Adding a character to a defined name??? (4 replies)
  187. [SOLVED:] Linked Spreadsheet (3 replies)
  188. [SOLVED:] Auto open folder and click button help (6 replies)
  189. [SOLVED:] About Subtract Function (13 replies)
  190. [SOLVED:] What's with this "Run time Error 1004?" (2 replies)
  191. [SOLVED:] Two Dynamic Named Range Copy/Paste (11 replies)
  192. [SOLVED:] Activating a pop up calendar by clicking in a cell (5 replies)
  193. [SOLVED:] Clear Cells Except First Row (8 replies)
  194. [SOLVED:] Read Each Row Output Text File (6 replies)
  195. Sleeper: Sub & Function (6 replies)
  196. [SOLVED:] List Box - Row Source (22 replies)
  197. [SOLVED:] Print all sheets (8 replies)
  198. [SOLVED:] Formula wont copy down correctly (3 replies)
  199. [SOLVED:] Mapping old to new with VBA (10 replies)
  200. Copy data from one file to another in Excel (2 replies)
  201. Sleeper: Copy columns to new sheets (4 replies)
  202. [SOLVED:] Unprotect cell (4 replies)
  203. [SOLVED:] Validation bugbears (6 replies)
  204. Sleeper: How could I fill automatically a column using VBA? (1 replies)
  205. Sleeper: Enter Data In Worksheet & Delete Empty Rows (4 replies)
  206. [SOLVED:] Finding selected optionbutton on a userform (8 replies)
  207. [SOLVED:] my firefiter (3 replies)
  208. [SOLVED:] Differrences between Rnd and Randomize (14 replies)
  209. [SOLVED:] Eliminating blinking cursor in UserForm Text box (2 replies)
  210. [SOLVED:] A loop question & write texts (13 replies)
  211. Sleeper: Macro's and Dates (7 replies)
  212. [SOLVED:] A Looping Question (2 replies)
  213. [SOLVED:] Rounding up question (3 replies)
  214. [SOLVED:] Grid Box (4 replies)
  215. [SOLVED:] Assign Macro to Button on Spreadsheet (4 replies)
  216. [SOLVED:] Call Function (4 replies)
  217. [SOLVED:] Output GUI Components' Names of Form (4 replies)
  218. [SOLVED:] Cell formating (5 replies)
  219. [SOLVED:] Change Font of UserForm1 (16 replies)
  220. [SOLVED:] Pitfalls of Earlier versions of Excel (3 replies)
  221. [SOLVED:] Enable CTRL+HOME, CTRL+END (7 replies)
  222. [SOLVED:] Crazy Request (4 replies)
  223. Sleeper: Conditional rows deleting (2 replies)
  224. [SOLVED:] Automatically rearrange columns (28 replies)
  225. [SLEEPER:] Adding a sheet (2 replies)
  226. Sleeper: Clear cell ranges if reference cell changes (8 replies)
  227. [SOLVED:] Pivot table (data range). (3 replies)
  228. Solved: Placing cursor in a specific textbox when form opens (26 replies)
  229. [SOLVED:] How to do sorting by values? (6 replies)
  230. Sleeper: Dynamically write data in cell (1 replies)
  231. [SOLVED:] Run Outlook from Excel (3 replies)
  232. Sleeper: Copy all files in a directory (3 replies)
  233. [SOLVED:] Question About the "Resume" Statement (3 replies)
  234. Sleeper: Conditional formats to make things easier on the eye (6 replies)
  235. Sleeper: Add unprotected rows to protected sheet (12 replies)
  236. Sleeper: Open web browser with specific address (3 replies)
  237. Sleeper: Copy all sheets (filter some rows) (2 replies)
  238. Sleeper: Problem in coding (5 replies)
  239. [SOLVED:] Compare 2 sheets different sizes (14 replies)
  240. Sleeper: File opens as read only (9 replies)
  241. [SOLVED:] Application.ScreenUpdating (26 replies)
  242. [SOLVED:] Combobox help (2 replies)
  243. [SOLVED:] Compile error: vba VIA vba (5 replies)
  244. [SOLVED:] Program to Identify duplicate entries (22 replies)
  245. Sleeper: Checking that a document in Word was printed from Excel? (3 replies)
  246. [SOLVED:] Advanced Filter Criteria Non Adjacent Cells (6 replies)
  247. [SOLVED:] Sorting macro (3 replies)
  248. [SOLVED:] Decimal Type ? (11 replies)
  249. [SOLVED:] Opening Text files (3 replies)
  250. [SOLVED:] CD-ROM - List File Attributes of Directory and Subdirectores (like brettdj's KB) (17 replies)