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: Very Custom Program (6 replies)
  2. SUM/COUNT CELLS BY FILL COLOUR (11 replies)
  3. Solved: sum values based upon 2 conditions (14 replies)
  4. excel spreadsheet to .EXE (1 replies)
  5. Solved: 2 dimensional dictionary object (7 replies)
  6. Hide value in Listbox if 2nd Column = 0 (1 replies)
  7. setting a workbook as a constant (3 replies)
  8. Count non-hidden cells in a pivot table (4 replies)
  9. Solved: Save As an Excel using VB (4 replies)
  10. Solved: excel2000 question (2 replies)
  11. Solved: Need help with Loop routine to enable 20+ checkboxes (6 replies)
  12. VBA Cell value mutiplication (4 replies)
  13. Solved: Find cell and return value as string (2 replies)
  14. Networkdays Formula (2 replies)
  15. Problems with Saving permissions (11 replies)
  16. Email Run-time error predicament (8 replies)
  17. Chnage formula to ONLY allow column D and K (3 replies)
  18. Solved: Vb New Line (3 replies)
  19. Solved: IF THEN COMMANDS?? (4 replies)
  20. A program to delete certain cells (3 replies)
  21. FONT COLOUR DROP DOWN ON CELL (14 replies)
  22. Data shifts on adding new customers (4 replies)
  23. Solved: ListView control with images (8 replies)
  24. Solved: Add To Code (1 replies)
  25. [SOLVED:] Summing Macro (2 replies)
  26. Solved: List all files in folders (4 replies)
  27. [SOLVED:] Dcount Last Character In Column (3 replies)
  28. [SOLVED:] Between dates in vba (4 replies)
  29. [SOLVED:] Ranges as arguments in a VBA function called from the formula bar (2 replies)
  30. Email/Excel/based on a condition (0 replies)
  31. Viewing records in workbook\worksheet form (0 replies)
  32. Debug Help with a Delete button (4 replies)
  33. [SOLVED:] Return a Range in a function (3 replies)
  34. Amend Forumla (6 replies)
  35. [SOLVED:] How to paste X in column A according to the length of column B (14 replies)
  36. How to select changing cells within a column (4 replies)
  37. [SOLVED:] Beep in Excel (8 replies)
  38. Modifying the existing graph (2 replies)
  39. [SOLVED:] Delete Rows that contain X in column Y? (24 replies)
  40. Rowheight plus a little bit more (8 replies)
  41. ploting the graph according to the sheet selected (2 replies)
  42. ploting the graph according to the sheet selected (2 replies)
  43. Solved: Automatically Update graph (10 replies)
  44. [SOLVED:] Tricky copy and paste macro (6 replies)
  45. Solved: Alternative to "vlookup" function (3 replies)
  46. Solved: VLOOKUP AND COLUMN FUNCTION (4 replies)
  47. Solved: SearchWord Help (13 replies)
  48. Solved: Amend Macro in worksheet Cashflow Yearly (9 replies)
  49. Logging into website (6 replies)
  50. Find and replace (Excel&Word) (1 replies)
  51. Solved: Dynamical generate name ranges (2 replies)
  52. Modify a macro (13 replies)
  53. Sum not correct (7 replies)
  54. Solved: Problem when trying to use close method of workbook object (11 replies)
  55. Solved: Script out of Range on Variant Array (4 replies)
  56. Validating values of a column in a file from another file (11 replies)
  57. Solved: Force Hide Formula Bar (2 replies)
  58. How to change mixed case names to proper case? (4 replies)
  59. [SOLVED:] Want to halp USEFORM (23 replies)
  60. Time and column spacing (3 replies)
  61. Solved: VLOOKUP Help (7 replies)
  62. Getting date format in comboboxes? (6 replies)
  63. Solved: Getting Rid of an Annoying Feature in Excel (9 replies)
  64. Run Command When Push Print Button? (1 replies)
  65. Calculating project time (8 replies)
  66. Solved: Copy more than one sheet to new workbook (7 replies)
  67. Solved: fill blank/black cells with 0 (10 replies)
  68. Can't get PasteSpecial to work (4 replies)
  69. Calculating installments left (7 replies)
  70. Accessing Addin functions with VBA (7 replies)
  71. Solved: subtract date/time formatted fields (11 replies)
  72. EXCEL CHARTS (4 replies)
  73. Solved: Timing my macro (5 replies)
  74. Solved: Colour entire row (10 replies)
  75. Solved: Userform query (6 replies)
  76. Comparing lists in columns? (6 replies)
  77. Categorize Deadlines Based On Past Due/Period Remaining (7 replies)
  78. Switch to an Active web browser windows with specific title (1 replies)
  79. Want to convert a Date (9 replies)
  80. Copy & Paste data from column I (6 replies)
  81. Solved: Copy & Paste and Adjust Data (6 replies)
  82. Solved: Dynamic List of Worksheet Names based on criteria (4 replies)
  83. Advance Filter (3 replies)
  84. [SOLVED:] VBA Email - Reply to Address (10 replies)
  85. Solved: Several issues with my code (9 replies)
  86. Convert sql to vba code (4 replies)
  87. Sleeper: Can't shut down excel.exe process (4 replies)
  88. UDF to calculate moving average (5 replies)
  89. Opening A Sheet From A Combobox (4 replies)
  90. Loop through listView & update checkbox (2 replies)
  91. Solved: Save current workbook to filename in format dd.mm.yy+string variable (9 replies)
  92. Solved: Validate Input Data in Userform (3 replies)
  93. Solved: Count number of cells and export to Word (6 replies)
  94. 'For' loop (6 replies)
  95. Solved: Dynamic Conditional Formatting (19 replies)
  96. Delete Rows : urgent (4 replies)
  97. Solved: Code Modify (9 replies)
  98. Solved: Copy subtotal values (4 replies)
  99. [SLEEPER:] Import multiple files into a single sheet (9 replies)
  100. Lookup code - I am missing something from my code!! (1 replies)
  101. Little help with Autofill please (4 replies)
  102. Copy and Add to Range (6 replies)
  103. Directory/Folder listing (12 replies)
  104. Checking entries to see if it is a valid entry (8 replies)
  105. Solved: Saving a copy of a spreadsheet, external file? (5 replies)
  106. Reversing a Macro (1 replies)
  107. Solved: Disable One Procedure While Another Runs Then Enable Again (4 replies)
  108. retrieving data in a list according to 3 criteria (14 replies)
  109. Solved: Download EXE files using VBA (2 replies)
  110. Solved: Data input from message box (13 replies)
  111. Solved: How can I delete all Queries in workbook? (2 replies)
  112. Solved: Combine Cells in multiple sheets into 1 sheet (13 replies)
  113. New column through existing ones (8 replies)
  114. Merging two worksheets (3 replies)
  115. Report on a Count of Colours Cells by Unique Row and by Column. (8 replies)
  116. [SOLVED:] Converting Criteria Listed in Excel For Data Validation (5 replies)
  117. [SOLVED:] Excel vs Access VBA (6 replies)
  118. How can you stop users from opening a file twice. (7 replies)
  119. Excel send to mail recipients help (1 replies)
  120. Sort excel and get top 10 and bottom 10 rows (3 replies)
  121. stop macro from replacing existing price and UCF cost assigned to a customer to zero (9 replies)
  122. Solved: Insert row with formatting and formulas (4 replies)
  123. if any cell in a row = > 70 Generate email Alert (4 replies)
  124. Solved: TextBox formula (13 replies)
  125. Solved: Inserting Formulas With Loops (9 replies)
  126. How to add a row in different files? (1 replies)
  127. Solved: How to pause a macro (8 replies)
  128. Solved: Populate Combobox in userform (14 replies)
  129. Solved: Updating Charts in VBA with listbox (23 replies)
  130. loop + array: complex for me :( (4 replies)
  131. Compare Data (7 replies)
  132. question on a constant + loop on a range (3 replies)
  133. more than 2 dims in an array? (2 replies)
  134. Solved: Need help removing a menu bar created in excel 2003 (2 replies)
  135. Macro screw ups (5 replies)
  136. Solved: Getting data from web site (2 replies)
  137. Fill Remaining Chart Percentage (1 replies)
  138. [SOLVED:] email via outlook from excel (16 replies)
  139. [SOLVED:] Desperately need VBA code help (7 replies)
  140. Error message when combining all excell wkbks in a folder using macro (2 replies)
  141. [SOLVED:] Make me look like an Excel/VBA Rockstar.... (32 replies)
  142. Last Active Row - Help modifying for Column (2 replies)
  143. Sumproduct Error (2 replies)
  144. MACROS (9 replies)
  145. Solved: Disabling cut copy paste on certain cells (1 replies)
  146. howto convert a excel file to a htlm file inclusive macro's (3 replies)
  147. Solved: How does this work? (13 replies)
  148. Use Do While instead of For/Next (4 replies)
  149. Protect excel workbook (11 replies)
  150. Solved: Searching specific text in cells in a column (12 replies)
  151. Solved: can't name darn worksheet! (4 replies)
  152. Automation error - Element not found (7 replies)
  153. Enter File Path in Webform then Submit (4 replies)
  154. Solved: worksheet_change event does not trigger on copy/paste (7 replies)
  155. Solved: VBA code to create / insert macro (4 replies)
  156. Open files with wildcards (1 replies)
  157. Return top 5 From a tabel of data (1 replies)
  158. Solved: Extract and convert Data to new sheet (3 replies)
  159. Working with Multiple Appls Simultaneously (4 replies)
  160. Add week ending date to newly created and renamed sheet? (3 replies)
  161. Format display in the comboBox (16 replies)
  162. Solved: Looping through Columns (3 replies)
  163. Make decisions (6 replies)
  164. How to obtain properties of graphical "line" (1 replies)
  165. Solved: Copy Cell Values from Non-adjacent columns (4 replies)
  166. creating graphs from vba form (17 replies)
  167. Error Checking (3 replies)
  168. Blink Control (5 replies)
  169. charting with vba (3 replies)
  170. Macro replacing text in each row by column (3 replies)
  171. Extracting Unique Values from a Column (4 replies)
  172. Running macro periodically (11 replies)
  173. Formula for cell value (11 replies)
  174. create moviedatabase, search IMDB.com (5 replies)
  175. Solved: Workbook_Open view in 100% zoom (25 replies)
  176. Reposting as original attachment was corrupt (3 replies)
  177. Solved: getting the file not found error (3 replies)
  178. Solved: Incrementing to next record (2 replies)
  179. Solved: Preventing a user from saving a file as a different name. (6 replies)
  180. find data from one workbook to another workbook (2 replies)
  181. [SOLVED:] Save location (4 replies)
  182. Reading Word files and search for key words (0 replies)
  183. Text to Columns question (2 replies)
  184. Solved: Hide Buttons in code? (3 replies)
  185. Flow chart (7 replies)
  186. Solved: Index / Match Multiple Criteria Issue (4 replies)
  187. Tidying up the code and adding functionality (0 replies)
  188. Flashing Cell (5 replies)
  189. 2 different color at the same cell? (6 replies)
  190. Solved: Top 3 highest values in range (5 replies)
  191. Macro to ask to find file (4 replies)
  192. [SOLVED:] Incorporating a version number (incremental) in filename (4 replies)
  193. Solved: Help with macro (4 replies)
  194. Solved: Last used cell (12 replies)
  195. Solved: Fill down formula (11 replies)
  196. making define name ranges to work for other worksheets (1 replies)
  197. nested If statement (12 replies)
  198. writting sum function in VBA (2 replies)
  199. Close out without saving (6 replies)
  200. COUNTIF for more than 1 thing on the same formula (5 replies)
  201. Solved: List box items selected but wrong message (2 replies)
  202. Macro to generate random number then User needs to guess that value (18 replies)
  203. Solved: Count tabs in Workbook (6 replies)
  204. [SOLVED:] Remove commas and spaces in the middle of a string (2 replies)
  205. Show running time of macro (4 replies)
  206. Filling Mandatory Cells in Excel (9 replies)
  207. VBA macro code to find last worked row or column (7 replies)
  208. Open multiple files as workbooks (2 replies)
  209. Listbox RowSource Requires Range or String (7 replies)
  210. Solved: Tool allocation forecast with multiple IF statements (6 replies)
  211. cannot createobject using "internetexplorer.application" (3 replies)
  212. Solved: Mousemove event with shape (3 replies)
  213. Solved: VBA - Get Range of a Range ??? How? (2 replies)
  214. Solved: range question (8 replies)
  215. Solved: How to Format Font in Middle of String? (8 replies)
  216. Solved: CountIF based on logical operators (1 replies)
  217. Solved: file generation + naming from a variable (3 replies)
  218. Solved: How to get a URL address from the cell value (7 replies)
  219. Sleeper: Copy data to new sheet to remove duplicates (3 replies)
  220. Convert data for Pivot Table (4 replies)
  221. Solved: Using String in a cell as reference for a cell (2 replies)
  222. Solved: Hide Columns Form (2 replies)
  223. Attaching Objects Code (1 replies)
  224. Solved: Get average table for each month in Column L (2 replies)
  225. Solved: Highlight the entire row on click (14 replies)
  226. Solved: Sorting by month of year (11 replies)
  227. Update macro to add tan border as shown in worksheet example (1 replies)
  228. Solved: Set Worksheet Name and Locate Range Info (7 replies)
  229. [SOLVED:] Ungrouping all Row and Column ranges in workbook (20 replies)
  230. Control Treeview (4 replies)
  231. Solved: Enter password as ***** (2 replies)
  232. ADODB, SQL, INSERT - force the type of inserted data (0 replies)
  233. Solved: Run Time Error 13 & Format Func in userform (6 replies)
  234. A sound on conditional formatting (3 replies)
  235. Advanced Filter Creating Named Range? (4 replies)
  236. Solved: Problem with Date Format (4 replies)
  237. Solved: Help in finishing the code (1 replies)
  238. Query data from two databases (2 replies)
  239. insert data in dialog box... (2 replies)
  240. Solved: How to Rename a Defined Name (1 replies)
  241. Solved: Extracting specific data (6 replies)
  242. Permutation two (4 replies)
  243. Solved: How to Identify Worksheet Name for Each Range (11 replies)
  244. Loop thru range, find and copy data to matching sheets (1 replies)
  245. excel programming issues (8 replies)
  246. Show user form (4 replies)
  247. Solved: VLOOKUP resuts (3 replies)
  248. code tweaking (1 replies)
  249. Solved: MenuMaker - disabling menu items (4 replies)
  250. Solved: Use textbox to display data related to the child node (6 replies)