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:] Cannot open file (Error 53) for writing (2 replies)
  2. [SOLVED:] ExcelDiet (8 replies)
  3. [SOLVED:] Manipulating a string in the form 11:22:33 (3 replies)
  4. Sleeper: Display files being searched (1 replies)
  5. [SOLVED:] Can VBA force an Excel file to open as read/write? (3 replies)
  6. [SOLVED:] Passing arguments/variables to Forms (4 replies)
  7. [SOLVED:] Help with percentage formula (2 replies)
  8. [SOLVED:] Updating Menu (2 replies)
  9. [SOLVED:] Worksheet Delete event? (19 replies)
  10. [SOLVED:] Select records that meet criteria in column E (8 replies)
  11. [SOLVED:] Can VBA do what cannot be done with Advanced Filtering? (13 replies)
  12. [SOLVED:] Double Lookup Formula (4 replies)
  13. [SOLVED:] Something wrong with Microsoft Excel Community Newgroups? (3 replies)
  14. [SOLVED:] Reference to cells (13 replies)
  15. [SOLVED:] Hidding a row from a function (4 replies)
  16. [SOLVED:] Count Rows Error (11 replies)
  17. [SOLVED:] Building a Sickness Spreadsheet (5 replies)
  18. [SOLVED:] Forced-In negative value (9 replies)
  19. Sleeper: Conditionnal copying rows (2 replies)
  20. Sleeper: Treeview selection problem (0 replies)
  21. log into an internet site (1 replies)
  22. [SOLVED:] Select from userform listbox (3 replies)
  23. Sleeper: Input Box - Exit Sub on Cancel (7 replies)
  24. Sleeper: Pivot Tables (1 replies)
  25. Sleeper: Cant get this code to work (5 replies)
  26. Sleeper: On date account (0 replies)
  27. [SOLVED:] Divide and place remainder in separate cell (2 replies)
  28. [SOLVED:] Macro to write code INTO the VBE (7 replies)
  29. [SOLVED:] Play Movie in Excel (9 replies)
  30. Solved: select a cell and filter data automatically (15 replies)
  31. [SLEEPER:] Remove hyperlinks (5 replies)
  32. Sleeper: Exporting data from Excel into MS Project (3 replies)
  33. Sleeper: Address from global and contact list in text box (0 replies)
  34. Sleeper: Moving cotents of a cell (4 replies)
  35. Sleeper: Result a search in a list box function (4 replies)
  36. Sleeper: Excel Macros (3 replies)
  37. Sleeper: Cancelling a browse box. (1 replies)
  38. Sleeper: 'Unchecked' references (9 replies)
  39. Sleeper: How to add a formula on one row directly below a pivot table? (5 replies)
  40. [SOLVED:] Sheet1(MyTab) (9 replies)
  41. [SOLVED:] Workbook Activate vs Select Revisited (3 replies)
  42. Advice: Tony Jollans' Clipboard Article (4 replies)
  43. [SOLVED:] Can you password protect the macros (4 replies)
  44. Sleeper: formula calculate time (3 replies)
  45. [SOLVED:] Pass Variables (3 replies)
  46. [SOLVED:] Retrieving old Target Value (1 replies)
  47. [SOLVED:] If data entered then prompt (2 replies)
  48. Sleeper: Troubleshooting Add Command (2 replies)
  49. [SOLVED:] Macro or conditional formatting??? (1 replies)
  50. Solved: VBA - Excel - XP - Ping (26 replies)
  51. [SOLVED:] Deleting from tree view (2 replies)
  52. [SOLVED:] MsgBox text...bold??? (3 replies)
  53. [SOLVED:] Dynamic Combo Box (5 replies)
  54. [SOLVED:] Conditional adding to a tree view (1 replies)
  55. Populating a LISTBOX based on sheet name (43 replies)
  56. Sleeper: VBA Function to total expense (4 replies)
  57. Sleeper: Macro to print area problem (3 replies)
  58. Sleeper: Selecting row through active cell (10 replies)
  59. [SOLVED:] I need Help with format date and data (11 replies)
  60. [SOLVED:] Help with required entry before copy macro works (3 replies)
  61. Sleeper: Checking for ColorIndex following Conditional Formatting (5 replies)
  62. Sleeper: InputBox Error (7 replies)
  63. Sleeper: Probleme with the position of values (0 replies)
  64. Sleeper: Copy worksheet (0 replies)
  65. [SOLVED:] Move Cursor in Text Box (2 replies)
  66. [SOLVED:] Modified Move Files from one hard drive to another vba (8 replies)
  67. Sleeper: Using Userforms (5 replies)
  68. [SOLVED:] Listview (9 replies)
  69. [SOLVED:] Input Box problems (20 replies)
  70. [SOLVED:] Multiple Instances of Excel (7 replies)
  71. Sleeper: DateTimePicker Control not displaying (2 replies)
  72. [SOLVED:] Finding 1st NonBlank Char in String (3 replies)
  73. [SOLVED:] Copying merged cells (2 replies)
  74. Sleeper: Function Question (12 replies)
  75. [SOLVED:] Deleting a sheet without a prompt (2 replies)
  76. [SOLVED:] How to launch a procedure on one another sheet? (9 replies)
  77. Solved: Methods to update an add-in (28 replies)
  78. Sleeper: Deactivate workbook after 3 login attempts (7 replies)
  79. [SOLVED:] Exporting VBA Modules (3 replies)
  80. [SOLVED:] Writing to an xlveryhidden sheet (7 replies)
  81. [SOLVED:] Trim? (5 replies)
  82. [SOLVED:] etting VBE Options Programatically (9 replies)
  83. [SOLVED:] Protect Sheets But Allow Data Entry From UserForm (16 replies)
  84. [SOLVED:] Outbox Outlook (9 replies)
  85. Excel to Word Label Mail Merge (6 replies)
  86. Sleeper: Problem with changing filenames (2 replies)
  87. [SOLVED:] Importing Sheets (3 replies)
  88. [SOLVED:] Select listbox item on userform through vba (4 replies)
  89. Sleeper: Search Function Problem (5 replies)
  90. [SOLVED:] Delete a folder (1 replies)
  91. [SOLVED:] Add-in for stock price update (3 replies)
  92. [SOLVED:] Copy InputBox (5 replies)
  93. [SOLVED:] Populate Combobox with Named Range (6 replies)
  94. [SOLVED:] Copying a workbook to selected folder (8 replies)
  95. Sleeper: How to add a formula at the bottom of a pivot table? (5 replies)
  96. Sleeper: Simple (but hard for me) excel problem..columns (14 replies)
  97. [SOLVED:] Hide rows based on values within range (5 replies)
  98. Solved: Error Numbers (6 replies)
  99. export data from ERP database (1 replies)
  100. [SOLVED:] Application.Calculation (2 replies)
  101. [SOLVED:] Remove Named Range (12 replies)
  102. Sleeper: Using intersect method (12 replies)
  103. Sleeper: Kill excel instance (18 replies)
  104. [SOLVED:] Change worksheet name according to cell (2 replies)
  105. [SOLVED:] More Info on Program "XLAppRest" (3 replies)
  106. [SOLVED:] If statement for Scatter Chart (2 replies)
  107. [SOLVED:] Read textfile contents into user form (8 replies)
  108. web queries (0 replies)
  109. UserForm & Spreadsheet updating problem (I am Back) (8 replies)
  110. Sleeper: Can I loop this ? (6 replies)
  111. [SOLVED:] Disable ComboBox event? (3 replies)
  112. Sleeper: VBA script to open, refresh pivot and save the file (1 replies)
  113. Sleeper: Excel Statistics add-in (2 replies)
  114. Sleeper: Formula calculate value (1 replies)
  115. [SOLVED:] Return value in cell (6 replies)
  116. [SOLVED:] TAB color (7 replies)
  117. Sleeper: TAB color revisited (1 replies)
  118. Sleeper: Small problem (1 replies)
  119. Sleeper: Open/save VBA projects (3 replies)
  120. [SOLVED:] Rounding to the nearest whole or .5 (15 replies)
  121. Sleeper: Creating own formula (8 replies)
  122. [SOLVED:] I want the path of the Workbook (3 replies)
  123. Sleeper: Delimited file: Assigning names to sheets,charts (3 replies)
  124. [SOLVED:] Formula time as text (6 replies)
  125. [SOLVED:] Multi Email idea for you (12 replies)
  126. Sleeper: Email Worksheet (19 replies)
  127. Sleeper: Emailing Excel Tabs (1 replies)
  128. [SOLVED:] Copy Multi WorkBooks To master (5 replies)
  129. Format Functions Excel Add-in! (19 replies)
  130. Sleeper: VBA macro instead of IF statements? (2 replies)
  131. Sleeper: Sort by interior.colorindex (8 replies)
  132. Solved: Keep userform on top at all times (22 replies)
  133. [SOLVED:] Guide for VBA functions (15 replies)
  134. [SOLVED:] Prompt windows on Save (3 replies)
  135. Sleeper: Code for Formulas & Input data via Userforms (2 replies)
  136. [SOLVED:] Need Formula Help (1 replies)
  137. [SOLVED:] How Do I Execute an Addin I Just Loaded?? (7 replies)
  138. Sleeper: Formula question (5 replies)
  139. [SOLVED:] Conditional Formatting (3 replies)
  140. Sleeper: Bordering rows help (again) (2 replies)
  141. Sleeper: Dr J's Progress Bar problem (5 replies)
  142. [SOLVED:] How do I code a userform (5 replies)
  143. Sleeper: Font and Colour of Generated File (1 replies)
  144. [SOLVED:] Randomize (4 replies)
  145. Sleeper: Copy column (1 replies)
  146. Sleeper: Code for browse button (4 replies)
  147. Sleeper: Hide unhide rows (2 replies)
  148. Sleeper: Where is the download (2 replies)
  149. Sleeper: Change the Filename before emailing? (0 replies)
  150. Solved: How do I "save as" with a predefined filename? (17 replies)
  151. [SOLVED:] Configuring the VBA Editor (2 replies)
  152. [SOLVED:] Insert Rows / Find Cell based on Shading (6 replies)
  153. [SOLVED:] Enable use of "Grouping" with Excel 2000 (4 replies)
  154. [SOLVED:] Protecting sheets using names from a "Defined Name" (2 replies)
  155. Sleeper: Looping checkbox in excel (1 replies)
  156. [SOLVED:] ShowDataForm (8 replies)
  157. Sleeper: Count same values (6 replies)
  158. Sleeper: Securing workbook as an add-in (8 replies)
  159. [SOLVED:] How Beneficial Is "Destination:=" to Copy? (3 replies)
  160. [SOLVED:] Making code as reusable/simple as possible (2 replies)
  161. [SOLVED:] How to highlight duplicate ROWS in excel (9 replies)
  162. Sleeper: How to hilight duplicate ROWS in excel(plz read message) (7 replies)
  163. Sleeper: Reducing file size (5 replies)
  164. [SOLVED:] Hiding Columns (3 replies)
  165. Sleeper: VBA Controlled Passwords (6 replies)
  166. [SOLVED:] Ensure at least one workbook open (4 replies)
  167. Sleeper: Unique values when compare (3 replies)
  168. [SOLVED:] Hyperlinking from Excel to Word bookmarks (4 replies)
  169. [SOLVED:] If current sheet is... (2 replies)
  170. [SOLVED:] Extract numbers from a range of cells (30 replies)
  171. [SOLVED:] Duplicate Comboboxes (2 replies)
  172. Sleeper: Custom Toolbars (5 replies)
  173. [SOLVED:] Characters (3 replies)
  174. Draw Line Arrow VBA,VBE,MACro (14 replies)
  175. Sleeper: Change color of variable (14 replies)
  176. [SOLVED:] Time in userform listbox (5 replies)
  177. [SOLVED:] Selecting Sheets by TAB Colour (4 replies)
  178. Solved: UserForm & Spreadsheet updating problem (35 replies)
  179. [SOLVED:] Stop Userform Events (10 replies)
  180. [SOLVED:] "CutCopyMode" . . . What Is It? (22 replies)
  181. Sleeper: Sort columns by cell color (2 replies)
  182. Sleeper: Self saving workbook (5 replies)
  183. [SOLVED:] Code runs on Office XP but not on Office 2003 (5 replies)
  184. [SOLVED:] Time in VBA (5 replies)
  185. [SOLVED:] Listbox multi select issue (4 replies)
  186. [SOLVED:] Arrrgh! My Excel Toolbar Is Corrupted!! (3 replies)
  187. [SOLVED:] A challenge for someone (33 replies)
  188. Sleeper: Cleaner Code (6 replies)
  189. Sleeper: Userform transfer variables? (19 replies)
  190. [SOLVED:] Removing the Toolbar Options/Customize function (8 replies)
  191. [SOLVED:] Another listbox selection problem (1 replies)
  192. [SOLVED:] sending an email from the file location (2 replies)
  193. [SOLVED:] Multi select list box (2 replies)
  194. Sleeper: Problem in Saving to Mp3 File back (1 replies)
  195. [SOLVED:] Problem with Application.InputBox (5 replies)
  196. Sleeper: Non-Printing Characters (5 replies)
  197. [SOLVED:] Bogus Range? (3 replies)
  198. [SOLVED:] Viewing listbox items problem (10 replies)
  199. [SOLVED:] Opening a workbook (9 replies)
  200. [SOLVED:] Listbox problem (5 replies)
  201. [SOLVED:] Array question (2 replies)
  202. Solved: Phantom Breakpoint (1 replies)
  203. Sleeper: Inserting spaces (6 replies)
  204. [SOLVED:] Copy cells to closed spreadsheet (3 replies)
  205. [SOLVED:] Excel Mod function error (3 replies)
  206. [SOLVED:] Date format in userform text box (6 replies)
  207. Sleeper: Like Function (2 replies)
  208. [SOLVED:] Challenging Formula Question on Timesheet Calcs (3 replies)
  209. [SOLVED:] -- in a formula (10 replies)
  210. Sleeper: Hiding error messages (10 replies)
  211. Sleeper: Transfering data value from 2 Wbook... (2 replies)
  212. Sleeper: Using J-Walk's FaceID Tool (38 replies)
  213. Sleeper: Pivot table and function (3 replies)
  214. [SOLVED:] Search worksheets in folder and sub folders (20 replies)
  215. [SOLVED:] Const for userform name? (5 replies)
  216. [SOLVED:] Replace macro (4 replies)
  217. [SOLVED:] How do you Create an Embedded ComboBox (3 replies)
  218. Sleeper: Memory or Cache Problem (4 replies)
  219. [SOLVED:] Putting values in text boxes (2 replies)
  220. [SOLVED:] Guidance and Direction (5 replies)
  221. Sleeper: Printing entire contents of a cell (2 replies)
  222. Sleeper: Searching For the Best Statement to Define a Named Range (6 replies)
  223. [SOLVED:] Formatconditions for dynamic range (4 replies)
  224. Sleeper: I am back with a new set of questions (3 replies)
  225. [SOLVED:] Statement Efficiency (3 replies)
  226. [SOLVED:] Cell Value in Header (7 replies)
  227. [SOLVED:] Need more efficient implementation (5 replies)
  228. VBA excel (1 replies)
  229. [SOLVED:] Autofilter via a form - not working (3 replies)
  230. Sleeper: Using tab key on a form (17 replies)
  231. [SOLVED:] UserForm - Print out - with Data (2 replies)
  232. [SOLVED:] How to Modify a Range Format (4 replies)
  233. Sleeper: Custom Icons in Excel (4 replies)
  234. auto open new file and save as range name (6 replies)
  235. [SOLVED:] Vlookup Help (12 replies)
  236. Sleeper: Time in VBA - Display's in Serial Number (3 replies)
  237. [SOLVED:] Check time (1 replies)
  238. [SOLVED:] Conditional Formatting a row - several conditions (15 replies)
  239. Sleeper: UDF - show partial results in formula palette (2 replies)
  240. [SOLVED:] Message Box (3 replies)
  241. Sleeper: How let the custom menu start with excel opened? (3 replies)
  242. [SOLVED:] Clarification on Array Type (5 replies)
  243. Sleeper: How manipulate dates?? (0 replies)
  244. [SOLVED:] Matching cells (1 replies)
  245. [SOLVED:] Make cert (8 replies)
  246. [SOLVED:] ActiveX Checkboxes on Worksheet (8 replies)
  247. [SOLVED:] One Routine for Multiple Menu Events (4 replies)
  248. [SOLVED:] Cells.Find not working properly (12 replies)
  249. [SOLVED:] Use of Dictionary (7 replies)
  250. Sleeper: UserForm with Feed back from the Excel Sheet (18 replies)