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: How do you return / pass values? (7 replies)
  2. Solved: Notification when macro is executed (1 replies)
  3. Notification when macro is executed (4 replies)
  4. Subtotals using Macro ... (2 replies)
  5. Solved: Green if zero, Red if not (10 replies)
  6. New Excel Application (7 replies)
  7. Solved: Partial String ListBox search to populate another ListBox (3 replies)
  8. Copy and paste data after printing (1 replies)
  9. Solved: move sheets to new book (array) (3 replies)
  10. collection issue with custom type variable (9 replies)
  11. Split text between cells Help Needed (0 replies)
  12. Sub or Function for IF ... (0 replies)
  13. Solved: Passing variables through properties (4 replies)
  14. Sort, Page Break and Page Header according to cell values in different worksheet (9 replies)
  15. Custom Sort (6 replies)
  16. Duplicate Master freeware utility? (3 replies)
  17. Simplify Code (3 replies)
  18. Solved: Remove ' from text (5 replies)
  19. Solved: Save in both Excel 2003 and 2007 (9 replies)
  20. Runtime error in macro (3 replies)
  21. Solved: Jump to last worksheet (10 replies)
  22. conditional adding through sheets in a loop. Novice. (3 replies)
  23. Multiple Charts To Multiple Slides (4 replies)
  24. Find and Replace Page Down in excel (3 replies)
  25. Solved: How can I create linked Vlookup data from multiple closed workbooks (10 replies)
  26. Solved: Restrict Menus & Right Click Menus & short keys (4 replies)
  27. Solved: Loop through sheets (1 replies)
  28. Solved: Edit code to change cell value (6 replies)
  29. Solved: find duplicate entries in colunms (2 replies)
  30. When using a combo bow to select a row (9 replies)
  31. Solved: Save button (2 replies)
  32. Solved: What can i do when it says not a legal object name.. and then wont let me do anythin? (2 replies)
  33. Solved: How can i?? Press a button and it will make a calculation of +30days! (4 replies)
  34. Solved: Save button (3 replies)
  35. UDT Question (4 replies)
  36. Placing in the same row as a spefic customer (1 replies)
  37. Place in first empty textbox????????? (0 replies)
  38. Code to allow A Customers ID to only go in a spread up to 3 times? (1 replies)
  39. Formula Error (3 replies)
  40. Sleeper: Linking worksheet together (0 replies)
  41. Solved: Removing numbers from a text block (2 replies)
  42. Solved: copy sheet and change formula reference (9 replies)
  43. Solved: Macro Problem - Hanging (8 replies)
  44. VBA Question - How to find the contents of one cell in another worksheet? (3 replies)
  45. Solved: Loop for Value True/ Copy 4 cells to other sheet (26 replies)
  46. [SOLVED:] Message Box Input calls Tab Name (7 replies)
  47. Print when Command button is pushed (4 replies)
  48. How to give a dataset corresponding ranges? (0 replies)
  49. Help using Excel as a database (10 replies)
  50. Font color (13 replies)
  51. highlight cells between two dates in cluding the cells with the dates (3 replies)
  52. Select check box on web page (5 replies)
  53. Run macro automatically when a cell value changes (8 replies)
  54. Number format Question? (4 replies)
  55. How to delete all rows that don't have a specific name - e.g. "XYZ" (8 replies)
  56. Insert column (2 replies)
  57. Excel Signing Invalid because of XLA location change (2 replies)
  58. Insert today's date, save file and close (2 replies)
  59. Solved: Alter Code To Allow Spread Sheet To Close (4 replies)
  60. IF STATEMENT TO extract result (8 replies)
  61. Advancedfilter Delete Row(s) (5 replies)
  62. Solved: Copy row of sheet2 (if data does not match sheet1). (3 replies)
  63. Solved: Copy range from one sheet to another (8 replies)
  64. Solved: adding locked cells via macro (16 replies)
  65. greatest date and time (6 replies)
  66. Pivot Page fields to new sheets (0 replies)
  67. Copy data from Multiple to SINGLE worksheet. (20 replies)
  68. Solved: Custom Formats (8 replies)
  69. Solved: Followhyperlink code (2 replies)
  70. VB code (2 replies)
  71. Last Duplicate Value in Column (7 replies)
  72. Create request (1 replies)
  73. How to compare the difference between 2 excel files (2 replies)
  74. How to enter date into pop up, which enters into spreadsheet (5 replies)
  75. Solved: variable not defined in (5 replies)
  76. Solved: Vlookup from data in unopened file? (25 replies)
  77. Solved: Available Resources issue (4 replies)
  78. Edit a cell depending on previous choice. (12 replies)
  79. Help with Replace Function (2 replies)
  80. Combine2 Name Colums to Create emails (2 replies)
  81. Set SummaryRow format (0 replies)
  82. Solved: Save as Filename with a variable text (1 replies)
  83. Copy variable range and copy to another sheet (9 replies)
  84. Error's want to help (9 replies)
  85. Solved: It's late, please help simplify this formula (3 replies)
  86. Solved: Change PivotTable Data Field in VBA (2 replies)
  87. Solved: Hide Row Based On First Few Letters (8 replies)
  88. Solved: Leave TextBoxes Blank (3 replies)
  89. Copy data from web (1 replies)
  90. Solved: Populate Listbox with Mulitple Columns (4 replies)
  91. Double Entries (4 replies)
  92. Processing XSD schemas using VBA (3 replies)
  93. Solved: Very Custom Program (6 replies)
  94. SUM/COUNT CELLS BY FILL COLOUR (11 replies)
  95. Solved: sum values based upon 2 conditions (14 replies)
  96. excel spreadsheet to .EXE (1 replies)
  97. Solved: 2 dimensional dictionary object (7 replies)
  98. Hide value in Listbox if 2nd Column = 0 (1 replies)
  99. setting a workbook as a constant (3 replies)
  100. Count non-hidden cells in a pivot table (4 replies)
  101. Solved: Save As an Excel using VB (4 replies)
  102. Solved: excel2000 question (2 replies)
  103. Solved: Need help with Loop routine to enable 20+ checkboxes (6 replies)
  104. VBA Cell value mutiplication (4 replies)
  105. Solved: Find cell and return value as string (2 replies)
  106. Networkdays Formula (2 replies)
  107. Problems with Saving permissions (11 replies)
  108. Email Run-time error predicament (8 replies)
  109. Chnage formula to ONLY allow column D and K (3 replies)
  110. Solved: Vb New Line (3 replies)
  111. Solved: IF THEN COMMANDS?? (4 replies)
  112. A program to delete certain cells (3 replies)
  113. FONT COLOUR DROP DOWN ON CELL (14 replies)
  114. Data shifts on adding new customers (4 replies)
  115. Solved: ListView control with images (8 replies)
  116. Solved: Add To Code (1 replies)
  117. [SOLVED:] Summing Macro (2 replies)
  118. Solved: List all files in folders (4 replies)
  119. [SOLVED:] Dcount Last Character In Column (3 replies)
  120. [SOLVED:] Between dates in vba (4 replies)
  121. [SOLVED:] Ranges as arguments in a VBA function called from the formula bar (2 replies)
  122. Email/Excel/based on a condition (0 replies)
  123. Viewing records in workbook\worksheet form (0 replies)
  124. Debug Help with a Delete button (4 replies)
  125. [SOLVED:] Return a Range in a function (3 replies)
  126. Amend Forumla (6 replies)
  127. [SOLVED:] How to paste X in column A according to the length of column B (14 replies)
  128. How to select changing cells within a column (4 replies)
  129. [SOLVED:] Beep in Excel (8 replies)
  130. Modifying the existing graph (2 replies)
  131. [SOLVED:] Delete Rows that contain X in column Y? (24 replies)
  132. Rowheight plus a little bit more (8 replies)
  133. ploting the graph according to the sheet selected (2 replies)
  134. ploting the graph according to the sheet selected (2 replies)
  135. Solved: Automatically Update graph (10 replies)
  136. Solved: Tricky copy and paste macro (6 replies)
  137. Solved: Alternative to "vlookup" function (3 replies)
  138. Solved: VLOOKUP AND COLUMN FUNCTION (4 replies)
  139. Solved: SearchWord Help (13 replies)
  140. Solved: Amend Macro in worksheet Cashflow Yearly (9 replies)
  141. Logging into website (6 replies)
  142. Find and replace (Excel&Word) (1 replies)
  143. Solved: Dynamical generate name ranges (2 replies)
  144. Modify a macro (13 replies)
  145. Sum not correct (7 replies)
  146. Solved: Problem when trying to use close method of workbook object (11 replies)
  147. Solved: Script out of Range on Variant Array (4 replies)
  148. Validating values of a column in a file from another file (11 replies)
  149. Solved: Force Hide Formula Bar (2 replies)
  150. How to change mixed case names to proper case? (4 replies)
  151. [SOLVED:] Want to halp USEFORM (23 replies)
  152. Time and column spacing (3 replies)
  153. Solved: VLOOKUP Help (7 replies)
  154. Getting date format in comboboxes? (6 replies)
  155. Solved: Getting Rid of an Annoying Feature in Excel (9 replies)
  156. Run Command When Push Print Button? (1 replies)
  157. Calculating project time (8 replies)
  158. Solved: Copy more than one sheet to new workbook (7 replies)
  159. Solved: fill blank/black cells with 0 (10 replies)
  160. Can't get PasteSpecial to work (4 replies)
  161. Calculating installments left (7 replies)
  162. Accessing Addin functions with VBA (7 replies)
  163. Solved: subtract date/time formatted fields (11 replies)
  164. EXCEL CHARTS (4 replies)
  165. Solved: Timing my macro (5 replies)
  166. Solved: Colour entire row (10 replies)
  167. Solved: Userform query (6 replies)
  168. Comparing lists in columns? (6 replies)
  169. Categorize Deadlines Based On Past Due/Period Remaining (7 replies)
  170. Switch to an Active web browser windows with specific title (1 replies)
  171. Want to convert a Date (9 replies)
  172. Copy & Paste data from column I (6 replies)
  173. Solved: Copy & Paste and Adjust Data (6 replies)
  174. Solved: Dynamic List of Worksheet Names based on criteria (4 replies)
  175. Advance Filter (3 replies)
  176. [SOLVED:] VBA Email - Reply to Address (10 replies)
  177. Solved: Several issues with my code (9 replies)
  178. Convert sql to vba code (4 replies)
  179. Sleeper: Can't shut down excel.exe process (4 replies)
  180. UDF to calculate moving average (5 replies)
  181. Opening A Sheet From A Combobox (4 replies)
  182. Loop through listView & update checkbox (2 replies)
  183. Solved: Save current workbook to filename in format dd.mm.yy+string variable (9 replies)
  184. Solved: Validate Input Data in Userform (3 replies)
  185. Solved: Count number of cells and export to Word (6 replies)
  186. 'For' loop (6 replies)
  187. Solved: Dynamic Conditional Formatting (19 replies)
  188. Delete Rows : urgent (4 replies)
  189. Solved: Code Modify (9 replies)
  190. Solved: Copy subtotal values (4 replies)
  191. Import multiple files into a single sheet (9 replies)
  192. Lookup code - I am missing something from my code!! (1 replies)
  193. Little help with Autofill please (4 replies)
  194. Copy and Add to Range (6 replies)
  195. Directory/Folder listing (12 replies)
  196. Checking entries to see if it is a valid entry (8 replies)
  197. Solved: Saving a copy of a spreadsheet, external file? (5 replies)
  198. Reversing a Macro (1 replies)
  199. Solved: Disable One Procedure While Another Runs Then Enable Again (4 replies)
  200. retrieving data in a list according to 3 criteria (14 replies)
  201. Solved: Download EXE files using VBA (2 replies)
  202. Solved: Data input from message box (13 replies)
  203. Solved: How can I delete all Queries in workbook? (2 replies)
  204. Solved: Combine Cells in multiple sheets into 1 sheet (13 replies)
  205. New column through existing ones (8 replies)
  206. Merging two worksheets (3 replies)
  207. Report on a Count of Colours Cells by Unique Row and by Column. (8 replies)
  208. Converting Criteria Listed in Excel For Data Validation (5 replies)
  209. [SOLVED:] Excel vs Access VBA (6 replies)
  210. How can you stop users from opening a file twice. (7 replies)
  211. Excel send to mail recipients help (1 replies)
  212. Sort excel and get top 10 and bottom 10 rows (3 replies)
  213. stop macro from replacing existing price and UCF cost assigned to a customer to zero (9 replies)
  214. Solved: Insert row with formatting and formulas (4 replies)
  215. if any cell in a row = > 70 Generate email Alert (4 replies)
  216. Solved: TextBox formula (13 replies)
  217. Solved: Inserting Formulas With Loops (9 replies)
  218. How to add a row in different files? (1 replies)
  219. Solved: How to pause a macro (8 replies)
  220. Solved: Populate Combobox in userform (14 replies)
  221. Solved: Updating Charts in VBA with listbox (23 replies)
  222. loop + array: complex for me :( (4 replies)
  223. Compare Data (7 replies)
  224. question on a constant + loop on a range (3 replies)
  225. more than 2 dims in an array? (2 replies)
  226. Solved: Need help removing a menu bar created in excel 2003 (2 replies)
  227. Macro screw ups (5 replies)
  228. Solved: Getting data from web site (2 replies)
  229. Fill Remaining Chart Percentage (1 replies)
  230. [SOLVED:] email via outlook from excel (16 replies)
  231. Desperately need VBA code help (7 replies)
  232. Error message when combining all excell wkbks in a folder using macro (2 replies)
  233. [SOLVED:] Make me look like an Excel/VBA Rockstar.... (32 replies)
  234. Last Active Row - Help modifying for Column (2 replies)
  235. Sumproduct Error (2 replies)
  236. MACROS (9 replies)
  237. Solved: Disabling cut copy paste on certain cells (1 replies)
  238. howto convert a excel file to a htlm file inclusive macro's (3 replies)
  239. Solved: How does this work? (13 replies)
  240. Use Do While instead of For/Next (4 replies)
  241. Protect excel workbook (11 replies)
  242. Solved: Searching specific text in cells in a column (12 replies)
  243. Solved: can't name darn worksheet! (4 replies)
  244. Automation error - Element not found (7 replies)
  245. Enter File Path in Webform then Submit (4 replies)
  246. Solved: worksheet_change event does not trigger on copy/paste (7 replies)
  247. Solved: VBA code to create / insert macro (4 replies)
  248. Open files with wildcards (1 replies)
  249. Return top 5 From a tabel of data (1 replies)
  250. Solved: Extract and convert Data to new sheet (3 replies)