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: Error Message (8 replies)
  2. Solved: Run-time error 1004 ... What am I missing? (4 replies)
  3. Solved: User Id And Time Of Data Entry (11 replies)
  4. Solved: Code location issues (31 replies)
  5. Solved: Transparent Toggle Button (15 replies)
  6. select issue (3 replies)
  7. Delete duplicates and sum values macro (1 replies)
  8. Trouble Closing File (9 replies)
  9. Count Values in List, Display Top x (9 replies)
  10. Solved: Range autofill (2 replies)
  11. VBA Code for Excel sheet access denied (4 replies)
  12. Solved: Another userform problem - frames (2 replies)
  13. Solved: User Form (9 replies)
  14. Solved: User form problem (9 replies)
  15. Transforming a doc content to Excel Table??!!Help! (1 replies)
  16. Solved: File Property (2 replies)
  17. Solved: Put cell values into array (6 replies)
  18. Solved: Delete row if object NOT found (18 replies)
  19. Options for triggering macro? (5 replies)
  20. make the characters in password entry "*" (1 replies)
  21. How make ?hint? to every picture (as button) on Sheet? (1 replies)
  22. Solved: Input box - force certain no of characters? (5 replies)
  23. Grocery lists (9 replies)
  24. User Form HELP (2 replies)
  25. Solved: User form numeric value (6 replies)
  26. Copy / Paste down (16 replies)
  27. Need macro to delete module content (2 replies)
  28. Open a file (2 replies)
  29. If Loop to paste (4 replies)
  30. how to change column width (4 replies)
  31. Solved: Vlookup returning all but one value?? (2 replies)
  32. Solved: Compare multple value (2 replies)
  33. Solved: Make range dynamic?! (3 replies)
  34. Sum (9 replies)
  35. Solved:Error when no comments found (3 replies)
  36. How to separate words in a cell (2 replies)
  37. Install addin through code (18 replies)
  38. Solved: MsgBox appears only once (2 replies)
  39. Fill Column According to 2 Criteria (6 replies)
  40. [SLEEPER:] Translating languages with vba (1 replies)
  41. Solved: How to select top three visible results? (7 replies)
  42. Macro to tel user new data has been added (6 replies)
  43. Solved: Create short name (2 replies)
  44. Solved: Open pdf file into Excel (2 replies)
  45. Solved: Convert with INDIRECT function (4 replies)
  46. Solved: Get functions list in Worksheet (5 replies)
  47. How to enter a formula in Excel via VBA .Formula properity? (1 replies)
  48. Arrays, one works one doesnt. (0 replies)
  49. Solved: Solved - Help to build a function to detect Captial Letters in a Cell (4 replies)
  50. Formula / Memory Limitations? (4 replies)
  51. mail a workbook (4 replies)
  52. activate original window at end of macro? (4 replies)
  53. Solved: Preserve sheets before Macros Runs (6 replies)
  54. Solved: Zoom and Setting Column Sizes (23 replies)
  55. Excel select data from mess (6 replies)
  56. Solved: hide/unhide rows based on value of target cell (2 replies)
  57. Solved: Delete information in a cell which also exist in another cell (5 replies)
  58. [SOLVED:] Factorial Subroutine (7 replies)
  59. Arrays and Accessing Elements by Index (4 replies)
  60. Select first Item in Listbox (19 replies)
  61. check credit cards (4 replies)
  62. Solved: a "Sorting" Macro (16 replies)
  63. Solved: repeat macro set number of times (4 replies)
  64. fill down code help (4 replies)
  65. Worksheet with alternative calculation methods (7 replies)
  66. Sleeper: US UK Date format issue (1 replies)
  67. Solved: send email from Excel with cells as body (2 replies)
  68. Text box/userform - 2DP? (2 replies)
  69. Quirk with Cond Formatting? (9 replies)
  70. Not able to enter a formula in a cell (3 replies)
  71. Custom validation (2 replies)
  72. Solved: Copy worksheets with msg box (3 replies)
  73. Solved: How to unprotect sheet in Excel in other program? (2 replies)
  74. Solved: Scroll Sheet Whilst Userform Active (7 replies)
  75. Solved: SELECT CERTAIN COLUMN BASED ON IF DATE BETWEEN (1 replies)
  76. For Each / Next Problem (4 replies)
  77. Solved: How to find the same numbers between two numbers (10 replies)
  78. Save some sheets with name (7 replies)
  79. How to add items to a combo box upon start? (6 replies)
  80. Text to column with line breaks (3 replies)
  81. find a way to copy link (0 replies)
  82. Solved: Counting colors (9 replies)
  83. Eliminate noise in data points (1 replies)
  84. Accessing a control in another (non-Office) application (13 replies)
  85. Solved: VBA formatting (5 replies)
  86. Solved: Highlight Row Based on Column Criteria (2 replies)
  87. Using XMLHTTPRequest within Firefox (4 replies)
  88. Solved: Problem with macro containing Vlookup - error handling?? (9 replies)
  89. Urgent help in VBA for averaging data (9 replies)
  90. Solved: Menu maker (32 replies)
  91. Changing Printers and page sizes in Excel (2 replies)
  92. Solved: .Find for empty string (2 replies)
  93. Solved: User form- Need grayed-out options (24 replies)
  94. Find "-n-t" in a string and skip it! (4 replies)
  95. Alter colour of cell text based on value of cell next to it? (5 replies)
  96. Solved: Selection of columns and clearing values (3 replies)
  97. Help programing an Excel Document (26 replies)
  98. prompt (2 replies)
  99. Data Extract from CSV File with date filter (3 replies)
  100. Solved: Is there a faster way to move these cells (5 replies)
  101. Solved: Split large data in various sheets (1 replies)
  102. Using option button properties (6 replies)
  103. Solved: Searching for multiple values within cell (9 replies)
  104. Accessing a macro in a locked project in another book. (1 replies)
  105. Delete Hidden Name Ranges (5 replies)
  106. Solved: Date Difference YY-MM-WW-DD-HH-MM-SS (4 replies)
  107. Solved: [Solved]Copying contents of textbox to clipboard (3 replies)
  108. Solved: Variant List (5 replies)
  109. Solved: Userform With Dropdown Selection (23 replies)
  110. Solved: Range Select from Found Cell (3 replies)
  111. Solved: Use Offset to return a value (6 replies)
  112. Solved: Force characters in text box (6 replies)
  113. macro - pivot table (0 replies)
  114. Solved: Extract Excel Files from Outlook (14 replies)
  115. Confusion about giving a chart a title (7 replies)
  116. Autofitting columns with a condition (2 replies)
  117. Defining constants (11 replies)
  118. Limiting the no of times a macro can run (3 replies)
  119. Cleaner VBA? - Building Array of Months (Fiscal Year) (1 replies)
  120. default sort behavior? (10 replies)
  121. Sleeper: Date Format (8 replies)
  122. list all excel files in a folder (1 replies)
  123. Solved: Re-use Automation Object Variables vs. release and re-Create (4 replies)
  124. Solved: Check Value of Array (20 replies)
  125. Creating a Master Spreadsheet (10 replies)
  126. Solved: Protect columnn widths (5 replies)
  127. CountIF (2 replies)
  128. Solved: Using Offset w/ rng variable (6 replies)
  129. code to copy the contents (8 replies)
  130. Using variable to define a range (8 replies)
  131. for....next (4 replies)
  132. wipe up MACRO code when WorkBooks Expire (5 replies)
  133. forms & multipage forms (3 replies)
  134. Solved: With-End With problem (9 replies)
  135. Solved: deleting rows again (3 replies)
  136. Auto SAve (2 replies)
  137. Copy & Paste ranges from multiple worksheets (3 replies)
  138. How to select & open latest time stamp workbook (1 replies)
  139. Formula from VBA doesn't work (8 replies)
  140. Option Buttons (2 replies)
  141. [SOLVED:] forms and modules (18 replies)
  142. Looping a macro to run at each change in variable (4 replies)
  143. Excel can't find path (2 replies)
  144. 2nd persistant messagebox occuring (4 replies)
  145. [SLEEPER:] Filldown a vlookup with no fixed start point (11 replies)
  146. Subscript out of range (4 replies)
  147. Solved: Class Modules?? (7 replies)
  148. Error Msg: vba code execution has been interrupted (1 replies)
  149. Solved: finding last row w/ (xldown) (6 replies)
  150. MsgBox (16 replies)
  151. Code in IE's Close event (5 replies)
  152. Pivot Table Group Months Year (1 replies)
  153. Solved: Extracting cell addresses from a formula (4 replies)
  154. Copy Data from Excel to Access, via Excel VBA (8 replies)
  155. formatting & updating a group textboxes (24 replies)
  156. Solved: Quickie- Explanation Properties/Objects (6 replies)
  157. Solved: Format(i, "00") works in 2003, bad in '07 (4 replies)
  158. Data Distribution (1 replies)
  159. Solved: Trigger a Macro with a hyperlink (2 replies)
  160. sum visible cells (10 replies)
  161. Solved: I can?t copy formula as text from one sheet to another. (9 replies)
  162. Percentages (3 replies)
  163. Solved: Copy column "A" to column "Q" (3 replies)
  164. Code Change (5 replies)
  165. Solved: What data type is this? (7 replies)
  166. Solved: Complicated calculations (9 replies)
  167. Solved: line continuation on formula? (11 replies)
  168. Row Delete (3 replies)
  169. formatting cell or using functions to remove text from cell A into cell B (7 replies)
  170. Show and Hide Label (2 replies)
  171. Learning VBA - is this a good starter project? (6 replies)
  172. Find last row, Offset (9 replies)
  173. Error Handler (4 replies)
  174. Solved: Delete same row from multiple sheets (7 replies)
  175. set range conditional on the numbers of rows (1 replies)
  176. Memory issues (#7) (27 replies)
  177. OptionButton madness... (5 replies)
  178. Solved: MisMatch error on joining two statements (2 replies)
  179. Problems using if-then in direct window (15 replies)
  180. Exit Sub w/out Error when Cancelling Routine (3 replies)
  181. Solved: Sum Function (6 replies)
  182. Solved: Calling subroutine (9 replies)
  183. Batch file (3 replies)
  184. VBA: Summing up a variable length row using ActiveCell.Formula (6 replies)
  185. Another one for the Experts (8 replies)
  186. Date Problem (2 replies)
  187. Solved: Importing data file into spreadsheet (1 replies)
  188. Open Multiple Files & Paste Data (4 replies)
  189. array (13 replies)
  190. VBA & Save File name HELP! (6 replies)
  191. Solved: INSERT CELL COMMENTS IN PROTECTED SHEET (6 replies)
  192. Function macro (2 replies)
  193. Non-contiguous ranges (different sheets!) (1 replies)
  194. Sheets Object problem (4 replies)
  195. Attention all Excel Experts (8 replies)
  196. Function to replace formulas (6 replies)
  197. Help appreciated (9 replies)
  198. inputbox help wanted (1 replies)
  199. Solved: IsBlank? Missing Library? (11 replies)
  200. Solved: Deleting Rows (11 replies)
  201. Solved: SumProduct vs. SUM ?? (22 replies)
  202. Solved: Activating a worksheet whose name is customized (3 replies)
  203. Left and Find Function Syntax (3 replies)
  204. How to copy two non-contiguous cells (11 replies)
  205. AD lastLogonTimestamp Is my code right? (1 replies)
  206. Postcode Macro - Amending (5 replies)
  207. Userform to change password in VBE (10 replies)
  208. Solved: Deleting Rows if a particular string doesnt exist in it (9 replies)
  209. conditonal formatting (1 replies)
  210. Disable Macro Security by VBA (3 replies)
  211. Hide Rows based several values (3 replies)
  212. How to skip the cell? (1 replies)
  213. Batch file execution (2 replies)
  214. Solved: Why do my URL's change after saving a workbook? (4 replies)
  215. Solved: UDF to emulate Weeknum() (15 replies)
  216. Shortcut to inserting rows (3 replies)
  217. How to remove everything but one sheet? (14 replies)
  218. unsort after sort (1 replies)
  219. How to search for phonetic similarities in Addresses (6 replies)
  220. Solved: Cell Arrangement (3 replies)
  221. question on 'Install or Uninstall ActiveX Controls (.ocx, .dll files)' (2 replies)
  222. Solved: VBA beginner exercise (9 replies)
  223. select case and looping problem (5 replies)
  224. Why does Object Browser Show Same Items Multiple Times? (13 replies)
  225. Solved: Shapes: Some Explanation Please (17 replies)
  226. Solved: Pass a workbook and worksheet name (14 replies)
  227. A Free ebook on Excel from MrExcel.com (2 replies)
  228. Solved: type mismatch on open (15 replies)
  229. Solved: Creating new worksheets (2 replies)
  230. Auto fill a form (3 replies)
  231. Solved: Non-Contiguous Copy PasteSpecial (10 replies)
  232. a list of all formula in activeworkbook (20 replies)
  233. Solved: Pass Variable Reference (2 replies)
  234. [SOLVED:] Stopwatch in Excel !!!! (2 replies)
  235. "Unable to get the Find property of the range class" Error (4 replies)
  236. Copying an entire sheet into another workbook (24 replies)
  237. Send Key function help (4 replies)
  238. Solved: Excel 2007 viewer (8 replies)
  239. Solved: Copy works, copy/paste doesn't... (bug?) (19 replies)
  240. VBA - conditional formatting on several sheets (6 replies)
  241. Solved: string problem (2 replies)
  242. Solved: Changing text in multiple cells (6 replies)
  243. WORKDAY function (3 replies)
  244. Count --> all worksheets (2 replies)
  245. convert a number into month (3 replies)
  246. Paste Special? (2 replies)
  247. Solved: Excel 2007 Multiplication Bug Da Capo... (4 replies)
  248. Delete unmatched records (7 replies)
  249. Shorter way of putting names to SeriesCollection (8 replies)
  250. Pivot Table Settings (1 replies)