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. Sleeper: Simple (but hard for me) excel problem..columns (14 replies)
  2. [SOLVED:] Hide rows based on values within range (5 replies)
  3. Solved: Error Numbers (6 replies)
  4. export data from ERP database (1 replies)
  5. [SOLVED:] Application.Calculation (2 replies)
  6. [SOLVED:] Remove Named Range (12 replies)
  7. Sleeper: Using intersect method (12 replies)
  8. Sleeper: Kill excel instance (18 replies)
  9. [SOLVED:] Change worksheet name according to cell (2 replies)
  10. [SOLVED:] More Info on Program "XLAppRest" (3 replies)
  11. [SOLVED:] If statement for Scatter Chart (2 replies)
  12. [SOLVED:] Read textfile contents into user form (8 replies)
  13. web queries (0 replies)
  14. UserForm & Spreadsheet updating problem (I am Back) (8 replies)
  15. Sleeper: Can I loop this ? (6 replies)
  16. [SOLVED:] Disable ComboBox event? (3 replies)
  17. Sleeper: VBA script to open, refresh pivot and save the file (1 replies)
  18. Sleeper: Excel Statistics add-in (2 replies)
  19. Sleeper: Formula calculate value (1 replies)
  20. [SOLVED:] Return value in cell (6 replies)
  21. [SOLVED:] TAB color (7 replies)
  22. Sleeper: TAB color revisited (1 replies)
  23. Sleeper: Small problem (1 replies)
  24. Sleeper: Open/save VBA projects (3 replies)
  25. [SOLVED:] Rounding to the nearest whole or .5 (15 replies)
  26. Sleeper: Creating own formula (8 replies)
  27. [SOLVED:] I want the path of the Workbook (3 replies)
  28. Sleeper: Delimited file: Assigning names to sheets,charts (3 replies)
  29. [SOLVED:] Formula time as text (6 replies)
  30. [SOLVED:] Multi Email idea for you (12 replies)
  31. Sleeper: Email Worksheet (19 replies)
  32. Sleeper: Emailing Excel Tabs (1 replies)
  33. [SOLVED:] Copy Multi WorkBooks To master (5 replies)
  34. Format Functions Excel Add-in! (19 replies)
  35. Sleeper: VBA macro instead of IF statements? (2 replies)
  36. Sleeper: Sort by interior.colorindex (8 replies)
  37. [SOLVED:] Keep userform on top at all times (22 replies)
  38. [SOLVED:] Guide for VBA functions (15 replies)
  39. [SOLVED:] Prompt windows on Save (3 replies)
  40. Sleeper: Code for Formulas & Input data via Userforms (2 replies)
  41. [SOLVED:] Need Formula Help (1 replies)
  42. [SOLVED:] How Do I Execute an Addin I Just Loaded?? (7 replies)
  43. Sleeper: Formula question (5 replies)
  44. [SOLVED:] Conditional Formatting (3 replies)
  45. Sleeper: Bordering rows help (again) (2 replies)
  46. Sleeper: Dr J's Progress Bar problem (5 replies)
  47. [SOLVED:] How do I code a userform (5 replies)
  48. Sleeper: Font and Colour of Generated File (1 replies)
  49. [SOLVED:] Randomize (4 replies)
  50. Sleeper: Copy column (1 replies)
  51. Sleeper: Code for browse button (4 replies)
  52. Sleeper: Hide unhide rows (2 replies)
  53. Sleeper: Where is the download (2 replies)
  54. Sleeper: Change the Filename before emailing? (0 replies)
  55. Solved: How do I "save as" with a predefined filename? (17 replies)
  56. [SOLVED:] Configuring the VBA Editor (2 replies)
  57. [SOLVED:] Insert Rows / Find Cell based on Shading (6 replies)
  58. [SOLVED:] Enable use of "Grouping" with Excel 2000 (4 replies)
  59. [SOLVED:] Protecting sheets using names from a "Defined Name" (2 replies)
  60. Sleeper: Looping checkbox in excel (1 replies)
  61. [SOLVED:] ShowDataForm (8 replies)
  62. Sleeper: Count same values (6 replies)
  63. Sleeper: Securing workbook as an add-in (8 replies)
  64. [SOLVED:] How Beneficial Is "Destination:=" to Copy? (3 replies)
  65. [SOLVED:] Making code as reusable/simple as possible (2 replies)
  66. [SOLVED:] How to highlight duplicate ROWS in excel (9 replies)
  67. [SLEEPER:] How to hilight duplicate ROWS in excel(plz read message) (7 replies)
  68. Sleeper: Reducing file size (5 replies)
  69. [SOLVED:] Hiding Columns (3 replies)
  70. Sleeper: VBA Controlled Passwords (6 replies)
  71. [SOLVED:] Ensure at least one workbook open (4 replies)
  72. Sleeper: Unique values when compare (3 replies)
  73. [SOLVED:] Hyperlinking from Excel to Word bookmarks (4 replies)
  74. [SOLVED:] If current sheet is... (2 replies)
  75. [SOLVED:] Extract numbers from a range of cells (30 replies)
  76. [SOLVED:] Duplicate Comboboxes (2 replies)
  77. Sleeper: Custom Toolbars (5 replies)
  78. [SOLVED:] Characters (3 replies)
  79. Draw Line Arrow VBA,VBE,MACro (14 replies)
  80. Sleeper: Change color of variable (14 replies)
  81. [SOLVED:] Time in userform listbox (5 replies)
  82. [SOLVED:] Selecting Sheets by TAB Colour (4 replies)
  83. Solved: UserForm & Spreadsheet updating problem (35 replies)
  84. [SOLVED:] Stop Userform Events (10 replies)
  85. [SOLVED:] "CutCopyMode" . . . What Is It? (22 replies)
  86. Sleeper: Sort columns by cell color (2 replies)
  87. Sleeper: Self saving workbook (5 replies)
  88. [SOLVED:] Code runs on Office XP but not on Office 2003 (5 replies)
  89. [SOLVED:] Time in VBA (5 replies)
  90. [SOLVED:] Listbox multi select issue (4 replies)
  91. [SOLVED:] Arrrgh! My Excel Toolbar Is Corrupted!! (3 replies)
  92. [SOLVED:] A challenge for someone (33 replies)
  93. Sleeper: Cleaner Code (6 replies)
  94. Sleeper: Userform transfer variables? (19 replies)
  95. [SOLVED:] Removing the Toolbar Options/Customize function (8 replies)
  96. [SOLVED:] Another listbox selection problem (1 replies)
  97. [SOLVED:] sending an email from the file location (2 replies)
  98. [SOLVED:] Multi select list box (2 replies)
  99. Sleeper: Problem in Saving to Mp3 File back (1 replies)
  100. [SOLVED:] Problem with Application.InputBox (5 replies)
  101. Sleeper: Non-Printing Characters (5 replies)
  102. [SOLVED:] Bogus Range? (3 replies)
  103. [SOLVED:] Viewing listbox items problem (10 replies)
  104. [SOLVED:] Opening a workbook (9 replies)
  105. [SOLVED:] Listbox problem (5 replies)
  106. [SOLVED:] Array question (2 replies)
  107. Solved: Phantom Breakpoint (1 replies)
  108. Sleeper: Inserting spaces (6 replies)
  109. [SOLVED:] Copy cells to closed spreadsheet (3 replies)
  110. [SOLVED:] Excel Mod function error (3 replies)
  111. [SOLVED:] Date format in userform text box (6 replies)
  112. Sleeper: Like Function (2 replies)
  113. [SOLVED:] Challenging Formula Question on Timesheet Calcs (3 replies)
  114. [SOLVED:] -- in a formula (10 replies)
  115. Sleeper: Hiding error messages (10 replies)
  116. Sleeper: Transfering data value from 2 Wbook... (2 replies)
  117. Sleeper: Using J-Walk's FaceID Tool (38 replies)
  118. [SLEEPER:] Pivot table and function (3 replies)
  119. [SOLVED:] Search worksheets in folder and sub folders (20 replies)
  120. [SOLVED:] Const for userform name? (5 replies)
  121. [SOLVED:] Replace macro (4 replies)
  122. [SOLVED:] How do you Create an Embedded ComboBox (3 replies)
  123. Sleeper: Memory or Cache Problem (4 replies)
  124. [SOLVED:] Putting values in text boxes (2 replies)
  125. [SOLVED:] Guidance and Direction (5 replies)
  126. Sleeper: Printing entire contents of a cell (2 replies)
  127. Sleeper: Searching For the Best Statement to Define a Named Range (6 replies)
  128. [SOLVED:] Formatconditions for dynamic range (4 replies)
  129. Sleeper: I am back with a new set of questions (3 replies)
  130. [SOLVED:] Statement Efficiency (3 replies)
  131. [SOLVED:] Cell Value in Header (7 replies)
  132. [SOLVED:] Need more efficient implementation (5 replies)
  133. VBA excel (1 replies)
  134. [SOLVED:] Autofilter via a form - not working (3 replies)
  135. Sleeper: Using tab key on a form (17 replies)
  136. [SOLVED:] UserForm - Print out - with Data (2 replies)
  137. [SOLVED:] How to Modify a Range Format (4 replies)
  138. Sleeper: Custom Icons in Excel (4 replies)
  139. auto open new file and save as range name (6 replies)
  140. [SOLVED:] Vlookup Help (12 replies)
  141. Sleeper: Time in VBA - Display's in Serial Number (3 replies)
  142. [SOLVED:] Check time (1 replies)
  143. [SOLVED:] Conditional Formatting a row - several conditions (15 replies)
  144. Sleeper: UDF - show partial results in formula palette (2 replies)
  145. [SOLVED:] Message Box (3 replies)
  146. Sleeper: How let the custom menu start with excel opened? (3 replies)
  147. [SOLVED:] Clarification on Array Type (5 replies)
  148. Sleeper: How manipulate dates?? (0 replies)
  149. [SOLVED:] Matching cells (1 replies)
  150. [SOLVED:] Make cert (8 replies)
  151. [SOLVED:] ActiveX Checkboxes on Worksheet (8 replies)
  152. [SOLVED:] One Routine for Multiple Menu Events (4 replies)
  153. [SOLVED:] Cells.Find not working properly (12 replies)
  154. [SOLVED:] Use of Dictionary (7 replies)
  155. Sleeper: UserForm with Feed back from the Excel Sheet (18 replies)
  156. Printer Details VBA (3 replies)
  157. [SOLVED:] Compare 2 columns, add blank rows (4 replies)
  158. [SOLVED:] Combine duplicate records and delete (3 replies)
  159. [SOLVED:] Use of Static Statement (9 replies)
  160. [SOLVED:] Using EOMONTH in code with Excel 2000 (7 replies)
  161. Sleeper: Pivot table (0 replies)
  162. Sleeper: Com addin (7 replies)
  163. Sleeper: Spliting of data inside each sheet (2 replies)
  164. [SOLVED:] Dynamic Arrays Question (2 replies)
  165. Sleeper: Searching, Autofilter, Double Input (2 replies)
  166. Sleeper: Threading in VBA (6 replies)
  167. Sleeper: Serial Port and Timer (sleep or delay) (4 replies)
  168. [SOLVED:] Check Box (6 replies)
  169. [SOLVED:] Windows search (7 replies)
  170. [SOLVED:] Using a closed Workbook file (3 replies)
  171. [SOLVED:] Stay in TextBox - UserForm (12 replies)
  172. [SOLVED:] UserForm and Adding up columns (9 replies)
  173. [SOLVED:] Data Validation (4 replies)
  174. [SOLVED:] Display decimal values in a text box (4 replies)
  175. [SOLVED:] How to Clear an Array (4 replies)
  176. [SOLVED:] VBA Coding Help (3 replies)
  177. [SOLVED:] CutCopyMode ... How Is It Used?? (3 replies)
  178. [SOLVED:] "OpenClipboard" Syntax (2 replies)
  179. Sleeper: Inserting Excel OLE Object (1 replies)
  180. Sleeper: Problem with sheet search (2 replies)
  181. [SOLVED:] If formula (6 replies)
  182. Dynamic Range and Pivot problem (13 replies)
  183. [SOLVED:] Assistance with finding the last value (3 replies)
  184. [SOLVED:] Datalabels not appearing on chart (4 replies)
  185. [SOLVED:] How do you make range A sheet 2 equal rangeB sheet 1?? (0 replies)
  186. Sleeper: Error: Push Excel Named Range Values to Bookmarks in Word (3 replies)
  187. Sleeper: Need formula help (9 replies)
  188. Sleeper: Inserting (not entire) rows after groups (excel 97) (10 replies)
  189. Sleeper: Javascript pop-ups/Web Queries (0 replies)
  190. Sleeper: Copy paste transpose multiple sheets onto one sheet (3 replies)
  191. [SOLVED:] How to Recover Columns That Are Off the Sheet (5 replies)
  192. Sleeper: Protected sheets and Links? (3 replies)
  193. [SOLVED:] Referencing Columns in loop (5 replies)
  194. Sleeper: Locking project after importing (2 replies)
  195. Sleeper: Using "Autofit" for merged cells (2 replies)
  196. [SOLVED:] Characters limit in Excel's Cells (2 replies)
  197. [SOLVED:] Bogus Dates (7 replies)
  198. [SOLVED:] In Macro - Clear Clipboard / Free up Memory (6 replies)
  199. [SOLVED:] Change color of background in MultiPage Control for UserForms (3 replies)
  200. Sleeper: Last Row in closed workbook (5 replies)
  201. [SOLVED:] Sort of an Excel calendar (6 replies)
  202. Sleeper: Checkboxes on worksheet (3 replies)
  203. [SOLVED:] Command Button to save & close workbook (3 replies)
  204. Sleeper: Search sheet (7 replies)
  205. Sleeper: Cell to reference sheet tabs in code. (3 replies)
  206. Sleeper: Using the sheet tabs as my validation list (2 replies)
  207. [SOLVED:] Link Excel files with color (10 replies)
  208. [SOLVED:] Multi line MsgBox (4 replies)
  209. Sleeper: Comparing arrays (6 replies)
  210. Sleeper: Managing Comments (5 replies)
  211. Sleeper: Reset of Auto-Filter (13 replies)
  212. Sleeper: Auto-copy if 'Yes' (2 replies)
  213. [SOLVED:] Merging cells problem (3 replies)
  214. [SOLVED:] Show Consecutive Entries.. (3 replies)
  215. [SOLVED:] Help with a range (3 replies)
  216. Sleeper: VBA PasteSpecial (xlAll) pastes picture not data (0 replies)
  217. [SOLVED:] Save with file name issue (4 replies)
  218. Sleeper: Paste not available due to Application event. (3 replies)
  219. [SOLVED:] Sort and insert blank row after groups (Excel97) (6 replies)
  220. Sleeper: IsUDF Function (22 replies)
  221. [SOLVED:] Strange Results From A Prompt (4 replies)
  222. Sleeper: Worksheet Protection (1 replies)
  223. [SOLVED:] Show Definitions of Named Styles (3 replies)
  224. Advice: Extending Rows and Columns (1 replies)
  225. [SOLVED:] Comparing part of a Cell volume against a range (8 replies)
  226. Sleeper: Logging of search results (7 replies)
  227. [SOLVED:] Unable to edit cells in excel (5 replies)
  228. [SOLVED:] Textbox Data (3 replies)
  229. [SOLVED:] Preventing comments (14 replies)
  230. [SOLVED:] Using If Then Else statement I think? (4 replies)
  231. [SOLVED:] Creating userforms help (10 replies)
  232. Sleeper: Current page method of pivot field failed (3 replies)
  233. Sleeper: Minimizing code (11 replies)
  234. Sleeper: Print VBA Userfrom for a Excel Workbook??? (1 replies)
  235. [SOLVED:] Do something when specific cell selected (10 replies)
  236. [SOLVED:] Button to hide/unhide all empty rows? (Excel 97) (15 replies)
  237. Sleeper: IsError (3 replies)
  238. Sleeper: Filling in website forms (1 replies)
  239. [SOLVED:] If Statement (12 replies)
  240. Sleeper: Worksheet accessing (5 replies)
  241. Sleeper: Quantity Limit on Copying Sheets (2 replies)
  242. Sleeper: Problem while running protected macro (5 replies)
  243. [SOLVED:] Variable Help (3 replies)
  244. [SOLVED:] This should be easy (6 replies)
  245. [SOLVED:] Assigning data from a range to a combobox (9 replies)
  246. Sleeper: A few questions (22 replies)
  247. Sleeper: Creating custom event (1 replies)
  248. Sleeper: Saveas dialog (7 replies)
  249. [SOLVED:] VBA Book recommendation (15 replies)
  250. Sleeper: Override Outlook Do you want to send option (1 replies)