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: User form- Need grayed-out options (24 replies)
  2. Find "-n-t" in a string and skip it! (4 replies)
  3. Alter colour of cell text based on value of cell next to it? (5 replies)
  4. Solved: Selection of columns and clearing values (3 replies)
  5. Help programing an Excel Document (26 replies)
  6. prompt (2 replies)
  7. Data Extract from CSV File with date filter (3 replies)
  8. Solved: Is there a faster way to move these cells (5 replies)
  9. Solved: Split large data in various sheets (1 replies)
  10. Using option button properties (6 replies)
  11. Solved: Searching for multiple values within cell (9 replies)
  12. Accessing a macro in a locked project in another book. (1 replies)
  13. Delete Hidden Name Ranges (5 replies)
  14. Solved: Date Difference YY-MM-WW-DD-HH-MM-SS (4 replies)
  15. Solved: [Solved]Copying contents of textbox to clipboard (3 replies)
  16. Solved: Variant List (5 replies)
  17. Solved: Userform With Dropdown Selection (23 replies)
  18. Solved: Range Select from Found Cell (3 replies)
  19. Solved: Use Offset to return a value (6 replies)
  20. Solved: Force characters in text box (6 replies)
  21. macro - pivot table (0 replies)
  22. Solved: Extract Excel Files from Outlook (14 replies)
  23. Confusion about giving a chart a title (7 replies)
  24. Autofitting columns with a condition (2 replies)
  25. Defining constants (11 replies)
  26. Limiting the no of times a macro can run (3 replies)
  27. Cleaner VBA? - Building Array of Months (Fiscal Year) (1 replies)
  28. default sort behavior? (10 replies)
  29. Sleeper: Date Format (8 replies)
  30. list all excel files in a folder (1 replies)
  31. Solved: Re-use Automation Object Variables vs. release and re-Create (4 replies)
  32. Solved: Check Value of Array (20 replies)
  33. Creating a Master Spreadsheet (10 replies)
  34. Solved: Protect columnn widths (5 replies)
  35. CountIF (2 replies)
  36. Solved: Using Offset w/ rng variable (6 replies)
  37. code to copy the contents (8 replies)
  38. Using variable to define a range (8 replies)
  39. for....next (4 replies)
  40. wipe up MACRO code when WorkBooks Expire (5 replies)
  41. forms & multipage forms (3 replies)
  42. Solved: With-End With problem (9 replies)
  43. Solved: deleting rows again (3 replies)
  44. Auto SAve (2 replies)
  45. Copy & Paste ranges from multiple worksheets (3 replies)
  46. How to select & open latest time stamp workbook (1 replies)
  47. Formula from VBA doesn't work (8 replies)
  48. Option Buttons (2 replies)
  49. [SOLVED:] forms and modules (18 replies)
  50. Looping a macro to run at each change in variable (4 replies)
  51. Excel can't find path (2 replies)
  52. 2nd persistant messagebox occuring (4 replies)
  53. [SLEEPER:] Filldown a vlookup with no fixed start point (11 replies)
  54. Subscript out of range (4 replies)
  55. Solved: Class Modules?? (7 replies)
  56. Error Msg: vba code execution has been interrupted (1 replies)
  57. Solved: finding last row w/ (xldown) (6 replies)
  58. MsgBox (16 replies)
  59. Code in IE's Close event (5 replies)
  60. Pivot Table Group Months Year (1 replies)
  61. Solved: Extracting cell addresses from a formula (4 replies)
  62. Copy Data from Excel to Access, via Excel VBA (8 replies)
  63. formatting & updating a group textboxes (24 replies)
  64. Solved: Quickie- Explanation Properties/Objects (6 replies)
  65. Solved: Format(i, "00") works in 2003, bad in '07 (4 replies)
  66. Data Distribution (1 replies)
  67. Solved: Trigger a Macro with a hyperlink (2 replies)
  68. sum visible cells (10 replies)
  69. Solved: I can?t copy formula as text from one sheet to another. (9 replies)
  70. Percentages (3 replies)
  71. Solved: Copy column "A" to column "Q" (3 replies)
  72. Code Change (5 replies)
  73. Solved: What data type is this? (7 replies)
  74. Solved: Complicated calculations (9 replies)
  75. Solved: line continuation on formula? (11 replies)
  76. Row Delete (3 replies)
  77. formatting cell or using functions to remove text from cell A into cell B (7 replies)
  78. Show and Hide Label (2 replies)
  79. Learning VBA - is this a good starter project? (6 replies)
  80. Find last row, Offset (9 replies)
  81. Error Handler (4 replies)
  82. Solved: Delete same row from multiple sheets (7 replies)
  83. set range conditional on the numbers of rows (1 replies)
  84. Memory issues (#7) (27 replies)
  85. OptionButton madness... (5 replies)
  86. Solved: MisMatch error on joining two statements (2 replies)
  87. Problems using if-then in direct window (15 replies)
  88. Exit Sub w/out Error when Cancelling Routine (3 replies)
  89. Solved: Sum Function (6 replies)
  90. Solved: Calling subroutine (9 replies)
  91. Batch file (3 replies)
  92. VBA: Summing up a variable length row using ActiveCell.Formula (6 replies)
  93. Another one for the Experts (8 replies)
  94. Date Problem (2 replies)
  95. Solved: Importing data file into spreadsheet (1 replies)
  96. Open Multiple Files & Paste Data (4 replies)
  97. array (13 replies)
  98. VBA & Save File name HELP! (6 replies)
  99. Solved: INSERT CELL COMMENTS IN PROTECTED SHEET (6 replies)
  100. Function macro (2 replies)
  101. Non-contiguous ranges (different sheets!) (1 replies)
  102. Sheets Object problem (4 replies)
  103. Attention all Excel Experts (8 replies)
  104. Function to replace formulas (6 replies)
  105. Help appreciated (9 replies)
  106. inputbox help wanted (1 replies)
  107. Solved: IsBlank? Missing Library? (11 replies)
  108. Solved: Deleting Rows (11 replies)
  109. Solved: SumProduct vs. SUM ?? (22 replies)
  110. Solved: Activating a worksheet whose name is customized (3 replies)
  111. Left and Find Function Syntax (3 replies)
  112. How to copy two non-contiguous cells (11 replies)
  113. AD lastLogonTimestamp Is my code right? (1 replies)
  114. Postcode Macro - Amending (5 replies)
  115. Userform to change password in VBE (10 replies)
  116. Solved: Deleting Rows if a particular string doesnt exist in it (9 replies)
  117. conditonal formatting (1 replies)
  118. Disable Macro Security by VBA (3 replies)
  119. Hide Rows based several values (3 replies)
  120. How to skip the cell? (1 replies)
  121. Batch file execution (2 replies)
  122. Solved: Why do my URL's change after saving a workbook? (4 replies)
  123. Solved: UDF to emulate Weeknum() (15 replies)
  124. Shortcut to inserting rows (3 replies)
  125. How to remove everything but one sheet? (14 replies)
  126. unsort after sort (1 replies)
  127. How to search for phonetic similarities in Addresses (6 replies)
  128. Solved: Cell Arrangement (3 replies)
  129. question on 'Install or Uninstall ActiveX Controls (.ocx, .dll files)' (2 replies)
  130. Solved: VBA beginner exercise (9 replies)
  131. select case and looping problem (5 replies)
  132. Why does Object Browser Show Same Items Multiple Times? (13 replies)
  133. Solved: Shapes: Some Explanation Please (17 replies)
  134. Solved: Pass a workbook and worksheet name (14 replies)
  135. A Free ebook on Excel from MrExcel.com (2 replies)
  136. Solved: type mismatch on open (15 replies)
  137. Solved: Creating new worksheets (2 replies)
  138. Auto fill a form (3 replies)
  139. Solved: Non-Contiguous Copy PasteSpecial (10 replies)
  140. a list of all formula in activeworkbook (20 replies)
  141. Solved: Pass Variable Reference (2 replies)
  142. [SOLVED:] Stopwatch in Excel !!!! (2 replies)
  143. "Unable to get the Find property of the range class" Error (4 replies)
  144. Copying an entire sheet into another workbook (24 replies)
  145. Send Key function help (4 replies)
  146. Solved: Excel 2007 viewer (8 replies)
  147. Solved: Copy works, copy/paste doesn't... (bug?) (19 replies)
  148. VBA - conditional formatting on several sheets (6 replies)
  149. Solved: string problem (2 replies)
  150. Solved: Changing text in multiple cells (6 replies)
  151. WORKDAY function (3 replies)
  152. Count --> all worksheets (2 replies)
  153. convert a number into month (3 replies)
  154. Paste Special? (2 replies)
  155. Solved: Excel 2007 Multiplication Bug Da Capo... (4 replies)
  156. Delete unmatched records (7 replies)
  157. Shorter way of putting names to SeriesCollection (8 replies)
  158. Pivot Table Settings (1 replies)
  159. Solved: Insert Rows and Transpose (2 replies)
  160. Add records to table (excel) (1 replies)
  161. Check for active Word document (1 replies)
  162. Amend code - (3 replies)
  163. Solved: Code execution interrupted (4 replies)
  164. Holiday planner/tracker (1 replies)
  165. Solved: Multiple Pivot Tables - simultaneous field change (6 replies)
  166. Critical Error: Odd Behavior on This particular Line all day (1 replies)
  167. Need a function to convert mm to inches (20 replies)
  168. output to textfile (2 replies)
  169. Change empty cell to a character in VBA (15 replies)
  170. Solved: Deleting group of rows if string pattern doesnt match (12 replies)
  171. [SOLVED:] Prevent Delete of Certain Sheets (13 replies)
  172. Solved: Loops and linking to Internet Explorer Excel file (3 replies)
  173. Solved: How to call an action based on input (4 replies)
  174. Setting values to a whole range at once (4 replies)
  175. Excel Add ins - Free Ones (3 replies)
  176. Not sure how to Amend current VBA code to do one more step (2 replies)
  177. Solved: Close all instances of IE (4 replies)
  178. Excel 2007 Multiplication Bug?! (5 replies)
  179. Calling Word macro from Excel macro (2 replies)
  180. Rename Multiple files. Help wanted (6 replies)
  181. [SOLVED:] Excel/Word timing problem (14 replies)
  182. Running a macro when excel startsup (2 replies)
  183. Get File Extension (4 replies)
  184. Commenting code (4 replies)
  185. Returning to Excel from Paste in Word (2 replies)
  186. Solved: Using Object Browser: Discover New Info (11 replies)
  187. Disable menu options (2 replies)
  188. Highlight row if date is this week (14 replies)
  189. Pivot table macro (3 replies)
  190. Buggy scope of a variable (22 replies)
  191. Error Handling: Complete exit (3 replies)
  192. Solved: Assist in Converting IF-Then to Select Case (12 replies)
  193. Adding text to existing text (3 replies)
  194. Freezing two top rows (2 replies)
  195. Getting Weekday as String and working with dates (12 replies)
  196. Help with a while wend loop (2 replies)
  197. Closing Excel.. (6 replies)
  198. Userform Save with contents of TextBoxes (5 replies)
  199. Solved: Find "/" in string & debug.print ? (4 replies)
  200. copy sheets and files (2 replies)
  201. IF-Then-Else in VBA help needed (9 replies)
  202. Solved: Debugging Immediate Window Question (16 replies)
  203. Solved: Read string variable while ignoring case sensitiveity (15 replies)
  204. Seek help for value (25 replies)
  205. I need a menu bar in a userform (3 replies)
  206. Hide "track changes" option (6 replies)
  207. I don?t want the hide cell to be copying!! How to do it? (3 replies)
  208. Solved: Sum Across unknown Number of Worksheets (16 replies)
  209. MultiPage -how to change Page color? (2 replies)
  210. increase numbers by percent in a specific column (2 replies)
  211. Still a challenge (8 replies)
  212. forms-comboboxes & textboxes (4 replies)
  213. Workbooks.Open Does not Error if Workbook is not Present (6 replies)
  214. Solved: CHANGE FROM ALL UPPER CASE (10 replies)
  215. Solved: Writing to specific sheets on specific cells (3 replies)
  216. [SOLVED:] Getting Data From a Closed Workbook (16 replies)
  217. Countif multiple criteria (18 replies)
  218. Solved: ScreenUpdating Issue? (7 replies)
  219. Can I use if, sum, match and offset functions to do this?? (4 replies)
  220. Pasting some tables form Excel in Word (14 replies)
  221. Solved: Passing row height properties to array (3 replies)
  222. Solved: Temporarily Remove Conditional Formatting (13 replies)
  223. date of last backup (2 replies)
  224. Click on a cell, which one was it? (18 replies)
  225. Listbox columns from 2 sheets (9 replies)
  226. Solved: Print Multiple Worksheets Error (4 replies)
  227. Solved: 'Custom' data validation (10 replies)
  228. Import Text File to tab in sheet (2 replies)
  229. loading all add-ins at one stroke (4 replies)
  230. Using sound in excel 2007 (2 replies)
  231. Form not working, Cracking me up! (19 replies)
  232. Solved: Copy multiple Excel Sheets (12 replies)
  233. Edit Button images (6 replies)
  234. advanced graphs - plotting (0 replies)
  235. must activate sheet before paste? (3 replies)
  236. Copy and paste macro different worksheets (5 replies)
  237. add a numerated worksheet (7 replies)
  238. Solved: tooltip (9 replies)
  239. HTTP: Yahoo Currency Conversion (11 replies)
  240. "Out of memory" (7 replies)
  241. Cell swapping (3 replies)
  242. Solved: WorksheetFunction.Vlookup Different Workbook Reference (20 replies)
  243. Listbox problem (8 replies)
  244. Problem with Excel 2003 XLA (Menu) Add-In (7 replies)
  245. Solved: Connect Combobox to Named Range (11 replies)
  246. Setting values for x-axis (3 replies)
  247. flashing label (3 replies)
  248. column question (6 replies)
  249. Solved: Weird workbook on open (6 replies)
  250. Solved: Method to instruct how many times to do something? (11 replies)