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. I want 'sum', not 'count'... (11 replies)
  2. Sleeper: Pivot table Refresh (1 replies)
  3. Solved: re-using macros and pivotTables (3 replies)
  4. Solved: Generating Payslip (11 replies)
  5. Solved: (c) copyright - anyway to stop this (3 replies)
  6. Problem launching Excel using code (14 replies)
  7. Import data from selected sheets of other wb (0 replies)
  8. Protection - Trial Version (5 replies)
  9. find, copy, delete, paste (13 replies)
  10. Copy Named Range (5 replies)
  11. [SOLVED:] Structure Suggestions? (13 replies)
  12. Closing Excel (2 replies)
  13. Solved: Skip Missing Worksheets (6 replies)
  14. Clear protected cells (4 replies)
  15. Overcome Excel "Save as" (2 replies)
  16. Excel Outlook Files (1 replies)
  17. shift on copy or paste (3 replies)
  18. Solved: Group rows (12 replies)
  19. Use of Randomize statement (3 replies)
  20. Help needed with excel macro problem! (17 replies)
  21. Solved: Fill Color issues (6 replies)
  22. file rename in vba (2 replies)
  23. code for inserting & Copying rows (12 replies)
  24. Continually check for next row, or check once & increment? (1 replies)
  25. Calculation based on 2 different columns and 3 different rows (15 replies)
  26. how to copy 2 sheets from a ws to another ws (3 replies)
  27. Losing last line when readig ASCII file into Array (6 replies)
  28. Solved: Loop to check numeric in userform textbox (4 replies)
  29. Solved: How To Find Text In Excel 2007 Binary Saved Workbooks... (6 replies)
  30. Compile Error in MS Excel 2007 (1 replies)
  31. Excel VBA (9 replies)
  32. Adding a menu to 2007 (3 replies)
  33. Solved: optionbutton to set commandbutton focus (2 replies)
  34. VBA Converters for Excel 95 (2 replies)
  35. macro & vlookup (0 replies)
  36. Formating range of cells (2 replies)
  37. [SOLVED:] Finding date in a range (4 replies)
  38. Solved: Multiple Users input updating Master (3 replies)
  39. Email and Font and color issue (0 replies)
  40. Why my Excel program doesn't work on other computer? Why? (2 replies)
  41. Solved: Runtime Error 9 - Subscript Out of Range - I must be missing something... (13 replies)
  42. Solved: Version control woes (10 replies)
  43. Solved: Opening a file via macro (9 replies)
  44. Solved: Add extra characters in all cells in column (5 replies)
  45. Solved: Do not paste information on hidden row (8 replies)
  46. Open Print Properties using VBA (43 replies)
  47. Reading data from a database without putting the value to any cell (13 replies)
  48. Solved: Find by cell format (5 replies)
  49. force excel to autosave (1 replies)
  50. Draw a line (0 replies)
  51. Userform auto-size (17 replies)
  52. MSFlexgrid merge cells (2 replies)
  53. Is it possible to create linked cells/aliases for cells? (5 replies)
  54. Can AutoFilter work with Colour based selection in Excel 2002? (2 replies)
  55. Solved: Formula in whole column (3 replies)
  56. Create on the fly goto sheet form (10 replies)
  57. Solved: Excel Range for Chart (3 replies)
  58. Word doc embedded object (3 replies)
  59. Solved: Error on opening workbook on another computer. (2 replies)
  60. Solved: Date/time format change with macro... (4 replies)
  61. Solved: Trying to set a cell color from a UDF _not_ a sub() (8 replies)
  62. NEWBIE TO EXCEL FORMATTING (2 replies)
  63. How to tell when the 'Notify' option is selected? (1 replies)
  64. sever all ties & links (1 replies)
  65. Solved: Lookup in VBA creating Errors (3 replies)
  66. Comboboxes and VBA i excel (3 replies)
  67. How to specify a formula for a cell? (3 replies)
  68. Select duplicates rows in a new sheet (1 replies)
  69. Passing a Parameter from Word to Excel (0 replies)
  70. Solved: Error Message (8 replies)
  71. Solved: Run-time error 1004 ... What am I missing? (4 replies)
  72. Solved: User Id And Time Of Data Entry (11 replies)
  73. Solved: Code location issues (31 replies)
  74. Solved: Transparent Toggle Button (15 replies)
  75. select issue (3 replies)
  76. Delete duplicates and sum values macro (1 replies)
  77. Trouble Closing File (9 replies)
  78. Count Values in List, Display Top x (9 replies)
  79. Solved: Range autofill (2 replies)
  80. VBA Code for Excel sheet access denied (4 replies)
  81. Solved: Another userform problem - frames (2 replies)
  82. Solved: User Form (9 replies)
  83. Solved: User form problem (9 replies)
  84. Transforming a doc content to Excel Table??!!Help! (1 replies)
  85. Solved: File Property (2 replies)
  86. Solved: Put cell values into array (6 replies)
  87. Solved: Delete row if object NOT found (18 replies)
  88. Options for triggering macro? (5 replies)
  89. make the characters in password entry "*" (1 replies)
  90. How make ?hint? to every picture (as button) on Sheet? (1 replies)
  91. Solved: Input box - force certain no of characters? (5 replies)
  92. Grocery lists (9 replies)
  93. User Form HELP (2 replies)
  94. Solved: User form numeric value (6 replies)
  95. Copy / Paste down (16 replies)
  96. Need macro to delete module content (2 replies)
  97. Open a file (2 replies)
  98. If Loop to paste (4 replies)
  99. how to change column width (4 replies)
  100. Solved: Vlookup returning all but one value?? (2 replies)
  101. Solved: Compare multple value (2 replies)
  102. Solved: Make range dynamic?! (3 replies)
  103. Sum (9 replies)
  104. Solved:Error when no comments found (3 replies)
  105. How to separate words in a cell (2 replies)
  106. Install addin through code (18 replies)
  107. Solved: MsgBox appears only once (2 replies)
  108. Fill Column According to 2 Criteria (6 replies)
  109. [SLEEPER:] Translating languages with vba (1 replies)
  110. Solved: How to select top three visible results? (7 replies)
  111. Macro to tel user new data has been added (6 replies)
  112. Solved: Create short name (2 replies)
  113. Solved: Open pdf file into Excel (2 replies)
  114. Solved: Convert with INDIRECT function (4 replies)
  115. Solved: Get functions list in Worksheet (5 replies)
  116. How to enter a formula in Excel via VBA .Formula properity? (1 replies)
  117. Arrays, one works one doesnt. (0 replies)
  118. Solved: Solved - Help to build a function to detect Captial Letters in a Cell (4 replies)
  119. Formula / Memory Limitations? (4 replies)
  120. mail a workbook (4 replies)
  121. activate original window at end of macro? (4 replies)
  122. Solved: Preserve sheets before Macros Runs (6 replies)
  123. Solved: Zoom and Setting Column Sizes (23 replies)
  124. Excel select data from mess (6 replies)
  125. Solved: hide/unhide rows based on value of target cell (2 replies)
  126. Solved: Delete information in a cell which also exist in another cell (5 replies)
  127. [SOLVED:] Factorial Subroutine (7 replies)
  128. Arrays and Accessing Elements by Index (4 replies)
  129. Select first Item in Listbox (19 replies)
  130. check credit cards (4 replies)
  131. Solved: a "Sorting" Macro (16 replies)
  132. Solved: repeat macro set number of times (4 replies)
  133. fill down code help (4 replies)
  134. Worksheet with alternative calculation methods (7 replies)
  135. Sleeper: US UK Date format issue (1 replies)
  136. Solved: send email from Excel with cells as body (2 replies)
  137. Text box/userform - 2DP? (2 replies)
  138. Quirk with Cond Formatting? (9 replies)
  139. Not able to enter a formula in a cell (3 replies)
  140. Custom validation (2 replies)
  141. Solved: Copy worksheets with msg box (3 replies)
  142. Solved: How to unprotect sheet in Excel in other program? (2 replies)
  143. [SOLVED:] Scroll Sheet Whilst Userform Active (7 replies)
  144. Solved: SELECT CERTAIN COLUMN BASED ON IF DATE BETWEEN (1 replies)
  145. For Each / Next Problem (4 replies)
  146. Solved: How to find the same numbers between two numbers (10 replies)
  147. Save some sheets with name (7 replies)
  148. How to add items to a combo box upon start? (6 replies)
  149. Text to column with line breaks (3 replies)
  150. find a way to copy link (0 replies)
  151. Solved: Counting colors (9 replies)
  152. Eliminate noise in data points (1 replies)
  153. Accessing a control in another (non-Office) application (13 replies)
  154. Solved: VBA formatting (5 replies)
  155. Solved: Highlight Row Based on Column Criteria (2 replies)
  156. Using XMLHTTPRequest within Firefox (4 replies)
  157. Solved: Problem with macro containing Vlookup - error handling?? (9 replies)
  158. Urgent help in VBA for averaging data (9 replies)
  159. Solved: Menu maker (32 replies)
  160. Changing Printers and page sizes in Excel (2 replies)
  161. Solved: .Find for empty string (2 replies)
  162. Solved: User form- Need grayed-out options (24 replies)
  163. Find "-n-t" in a string and skip it! (4 replies)
  164. Alter colour of cell text based on value of cell next to it? (5 replies)
  165. Solved: Selection of columns and clearing values (3 replies)
  166. Help programing an Excel Document (26 replies)
  167. prompt (2 replies)
  168. Data Extract from CSV File with date filter (3 replies)
  169. Solved: Is there a faster way to move these cells (5 replies)
  170. Solved: Split large data in various sheets (1 replies)
  171. Using option button properties (6 replies)
  172. Solved: Searching for multiple values within cell (9 replies)
  173. Accessing a macro in a locked project in another book. (1 replies)
  174. Delete Hidden Name Ranges (5 replies)
  175. Solved: Date Difference YY-MM-WW-DD-HH-MM-SS (4 replies)
  176. Solved: [Solved]Copying contents of textbox to clipboard (3 replies)
  177. Solved: Variant List (5 replies)
  178. Solved: Userform With Dropdown Selection (23 replies)
  179. Solved: Range Select from Found Cell (3 replies)
  180. Solved: Use Offset to return a value (6 replies)
  181. Solved: Force characters in text box (6 replies)
  182. macro - pivot table (0 replies)
  183. Solved: Extract Excel Files from Outlook (14 replies)
  184. Confusion about giving a chart a title (7 replies)
  185. Autofitting columns with a condition (2 replies)
  186. Defining constants (11 replies)
  187. Limiting the no of times a macro can run (3 replies)
  188. Cleaner VBA? - Building Array of Months (Fiscal Year) (1 replies)
  189. default sort behavior? (10 replies)
  190. Sleeper: Date Format (8 replies)
  191. list all excel files in a folder (1 replies)
  192. Solved: Re-use Automation Object Variables vs. release and re-Create (4 replies)
  193. Solved: Check Value of Array (20 replies)
  194. Creating a Master Spreadsheet (10 replies)
  195. Solved: Protect columnn widths (5 replies)
  196. CountIF (2 replies)
  197. Solved: Using Offset w/ rng variable (6 replies)
  198. code to copy the contents (8 replies)
  199. Using variable to define a range (8 replies)
  200. for....next (4 replies)
  201. wipe up MACRO code when WorkBooks Expire (5 replies)
  202. forms & multipage forms (3 replies)
  203. Solved: With-End With problem (9 replies)
  204. Solved: deleting rows again (3 replies)
  205. Auto SAve (2 replies)
  206. Copy & Paste ranges from multiple worksheets (3 replies)
  207. How to select & open latest time stamp workbook (1 replies)
  208. Formula from VBA doesn't work (8 replies)
  209. Option Buttons (2 replies)
  210. [SOLVED:] forms and modules (18 replies)
  211. Looping a macro to run at each change in variable (4 replies)
  212. Excel can't find path (2 replies)
  213. 2nd persistant messagebox occuring (4 replies)
  214. [SLEEPER:] Filldown a vlookup with no fixed start point (11 replies)
  215. Subscript out of range (4 replies)
  216. Solved: Class Modules?? (7 replies)
  217. Error Msg: vba code execution has been interrupted (1 replies)
  218. Solved: finding last row w/ (xldown) (6 replies)
  219. MsgBox (16 replies)
  220. Code in IE's Close event (5 replies)
  221. Pivot Table Group Months Year (1 replies)
  222. Solved: Extracting cell addresses from a formula (4 replies)
  223. Copy Data from Excel to Access, via Excel VBA (8 replies)
  224. formatting & updating a group textboxes (24 replies)
  225. Solved: Quickie- Explanation Properties/Objects (6 replies)
  226. Solved: Format(i, "00") works in 2003, bad in '07 (4 replies)
  227. Data Distribution (1 replies)
  228. Solved: Trigger a Macro with a hyperlink (2 replies)
  229. sum visible cells (10 replies)
  230. Solved: I can?t copy formula as text from one sheet to another. (9 replies)
  231. Percentages (3 replies)
  232. Solved: Copy column "A" to column "Q" (3 replies)
  233. Code Change (5 replies)
  234. Solved: What data type is this? (7 replies)
  235. Solved: Complicated calculations (9 replies)
  236. Solved: line continuation on formula? (11 replies)
  237. Row Delete (3 replies)
  238. formatting cell or using functions to remove text from cell A into cell B (7 replies)
  239. Show and Hide Label (2 replies)
  240. Learning VBA - is this a good starter project? (6 replies)
  241. Find last row, Offset (9 replies)
  242. Error Handler (4 replies)
  243. Solved: Delete same row from multiple sheets (7 replies)
  244. set range conditional on the numbers of rows (1 replies)
  245. Memory issues (#7) (27 replies)
  246. OptionButton madness... (5 replies)
  247. Solved: MisMatch error on joining two statements (2 replies)
  248. Problems using if-then in direct window (15 replies)
  249. Exit Sub w/out Error when Cancelling Routine (3 replies)
  250. Solved: Sum Function (6 replies)