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. DoEvents ActiveWorkbook.RefreshAll Run second part of Macro Once Complete (4 replies)
  2. Conditional Formatting in VBA (9 replies)
  3. Tough one (7 replies)
  4. Solved: Variables in String Issue (12 replies)
  5. Solved: Macro Error (5 replies)
  6. I have a dynamic SUM function problem (1 replies)
  7. Check if a value is in an array (4 replies)
  8. Solved: % problems (3 replies)
  9. Drop down on every cell in column (10 replies)
  10. How to submit a web form without a name? (0 replies)
  11. Finds row count, but only 99% of the time (3 replies)
  12. Solved: Resources - Download (4 replies)
  13. scrolling through each entry (3 replies)
  14. Conditional Subtotal Help (1 replies)
  15. Systematic access of files within directory (9 replies)
  16. Solved: Help with code to fill in emply code in worksheet (2 replies)
  17. Solved: Modifying workbook links (7 replies)
  18. Solved: Save worksheet as new workbook, with macros disabled (3 replies)
  19. Userform from hidden worksheet (6 replies)
  20. Clear Cell Value before re-running the VBA (4 replies)
  21. How to save intermediate values in a VBA code execution? (1 replies)
  22. Conditional Format based on two column criteria (3 replies)
  23. Solved: Excel 2003 Userform not posting until its closed (17 replies)
  24. Solved: What type of control do I need? (2 replies)
  25. [SLEEPER:] For..Next Loop with problem (6 replies)
  26. Solved: Why It doesn't find all hyperlinks? (7 replies)
  27. Solved: Adding Customers to my project (5 replies)
  28. Filters not applying in VBA code (2 replies)
  29. Problem in displaying a progress bar (2 replies)
  30. EXCEL VBA HELP SENDMAIL (1 replies)
  31. VBA Recalculation? (7 replies)
  32. Solved: Using SumIf with a Date Range as the Criteria (11 replies)
  33. Solved: Split string into two columns (2 replies)
  34. Solved: put current date in a column if any change in row (10 replies)
  35. Can not get data to change when I format the cells (12 replies)
  36. [SOLVED:] Filtering data up to a predetermined cumulative total (9 replies)
  37. Solved: Update Links window appears, why? (1 replies)
  38. How can one unlock a VBA project (and it's modules) using vba (6 replies)
  39. view two different sheets in same workbook (2 replies)
  40. Solved: Conditional drop-down lists (2 replies)
  41. Solved: Find the min or Max value in an autofiltered range (3 replies)
  42. Solved: VBA code to copy range to another specific range (4 replies)
  43. [SOLVED:] Formula to extract Lotus Notes username (6 replies)
  44. Solved: Subfolders (5 replies)
  45. Loop row deletion code through multiple sheets (7 replies)
  46. copying trough lock cells (18 replies)
  47. How to Change the Axis Numbers Color on a Chart (6 replies)
  48. Is this a solution for sumproduct? (8 replies)
  49. Creating new tabs (12 replies)
  50. Force Save to specific Folder (4 replies)
  51. Emailing multiple attachments from Excel (2 replies)
  52. test file name (1 replies)
  53. Solved: Change Password - Multiple Files+Common Password (6 replies)
  54. Solved: Keep form on top while keeping full excel functionality (3 replies)
  55. Macro to save as filename and sheet name (7 replies)
  56. add a # of hours to a time? (12 replies)
  57. Solved: String into Array (4 replies)
  58. Solved: Select columns to copy (9 replies)
  59. Solved: Error 1004 Bad Range definition? (4 replies)
  60. Expiry Date Validations (15 replies)
  61. Solved: Chart formatting with VBA (2 replies)
  62. Runtime Error 1004 (1 replies)
  63. Solved: highlighting a row in excel if selected (6 replies)
  64. Solved: Set focus on a control (4 replies)
  65. Solved: hightlight highest time (6 replies)
  66. Solved: That Pesky #REF Error (5 replies)
  67. copy column (1 replies)
  68. How to Detect If .csv file Is Open in Win 7 (2 replies)
  69. Find a value in a text file and remove the entire line (1 replies)
  70. Generate PDF file (1 replies)
  71. Do Loop help (1 replies)
  72. Solved: Automating Scipt (3 replies)
  73. Convert days into months (8 replies)
  74. Importing columns from another file into current spreadsheet (2 replies)
  75. Solved: Listbox RowSource from Access (3 replies)
  76. copy help (3 replies)
  77. Solved: Need a Function or Vlookup to replace Nested If (4 replies)
  78. List of files in a folder and sub folder (4 replies)
  79. Solved: Forms on moving values (3 replies)
  80. VBA Excel Addin - appearing in Project explorer and not in Extras-Addins list (2 replies)
  81. Insert hyperlink function to active cell (2 replies)
  82. Solved: #NA Error with VLookup (5 replies)
  83. Solved: Temporarily Change BG and Font Color of Active Cell (16 replies)
  84. Solved: Macro. (2 replies)
  85. Solved: Spreadsheet Max'd Out (4 replies)
  86. Solved: count of different products (17 replies)
  87. Why would scrolling cause Application.InputBox "Cancel" behavior? (5 replies)
  88. Copy to Last Row (7 replies)
  89. Solved: Sorting Alphanumerics and Extracting numbers from them. (26 replies)
  90. Solved: Mapping search (11 replies)
  91. How to add scroll bar in userfrom (1 replies)
  92. Solved: VBA macro - conditional column fill (23 replies)
  93. Matching elements of two character arrays (3 replies)
  94. Solved: To Copy Cell in other sheets (6 replies)
  95. Sending email with lotus notes using data from excel (0 replies)
  96. Redundant code (10 replies)
  97. Making a settable clock in VBA (1 replies)
  98. VBScript and Excel Addins (2 replies)
  99. Excel VBA Change text colour depending on another cell's content (6 replies)
  100. Obtaning current date time through VBA (1 replies)
  101. Solved: Reading data-range from excel workbook (3 replies)
  102. Solved: BeforeClose event not working (1 replies)
  103. Solved: Print Preview - Detect (1 replies)
  104. Solved: Macro explain. (4 replies)
  105. Open a subfolder deeper than the first (0 replies)
  106. Problem with RecordSet and "LIKE" Operator (3 replies)
  107. How to check on open event for macro (1 replies)
  108. Moving data on networked drives (0 replies)
  109. Weekday Conditional Formatting (12 replies)
  110. Solved: recalculate a function (3 replies)
  111. Explain Excel’s Task Bar’s Toolbar Options (3 replies)
  112. Problem with deleting files (0 replies)
  113. Sorting quetion (2 replies)
  114. Solved: Viewing Hyperlink locations (2 replies)
  115. Solved: FIND, COPY AND PASTE (6 replies)
  116. Open the Task Pane (1 replies)
  117. Solved: workaround for using PNG files (3 replies)
  118. Solved: Combining workbooks into one workbook with a part of the a filename (16 replies)
  119. ref the activecell value in an inactive sheet (3 replies)
  120. I am in way over my head Need help (33 replies)
  121. Solved: Check Group Rows For Non Mathes (2 replies)
  122. Solved: Cycle through validation list and spit out value of a specified cell (2 replies)
  123. Solved: automaticaly fill date of write (5 replies)
  124. Solved: range value (5 replies)
  125. Embedding objects Excel 2007 (4 replies)
  126. Find workbook name when macro run in add-in file (9 replies)
  127. Solved: Get length of string inside parentheses (8 replies)
  128. Manage all Hyperlinks in Workbook from new Worksheet (9 replies)
  129. Find data only specified Range ?? (9 replies)
  130. Caculating time between dates and counting if another criteria is met (1 replies)
  131. I'm trying to create a time sheet with stopwatch (16 replies)
  132. Solved: Only run code if staffnumber is equal to xxxxx (2 replies)
  133. chart help (1 replies)
  134. macro (6 replies)
  135. Turning off Autofilters & formatting (2 replies)
  136. VBA Sheet Name (5 replies)
  137. Don't exit if there was no button clicked (3 replies)
  138. Error during compile (0 replies)
  139. Urgent - Countif as an array formula problem! (2 replies)
  140. Solved: Arrays (3 replies)
  141. Solved: Help with Userform (4 replies)
  142. Prompting User to Select a Data Range (4 replies)
  143. Change button focus (6 replies)
  144. Solved: If Range Is Nothing (4 replies)
  145. Solved: Macro for Insertion of Lines between data (7 replies)
  146. XML and VBA (1 replies)
  147. Problem with Paste Picture Link (14 replies)
  148. Deselecting double clicked item in listbox (4 replies)
  149. Solved: seperating folder and filename (7 replies)
  150. Solved: xls to xlsm files. (4 replies)
  151. Excel 2007 Crashes Frequently (0 replies)
  152. custom error message box (3 replies)
  153. Turkish character issue in query from SQL server (2 replies)
  154. microsoft developer map (0 replies)
  155. Solved: Delete used rows in worksheet(sounds easy) (15 replies)
  156. Macro to find the string before special character from Right (4 replies)
  157. renaming a file (3 replies)
  158. need vba code to automatically format cell as hyperlink (1 replies)
  159. Solved: VBA summation errors in macro (24 replies)
  160. Solved: how to check if a desktop shortcut exists (1 replies)
  161. links to closed workbooks (1 replies)
  162. Excel Pivot Table Failing to Calculate an Average on a Calculated Field (4 replies)
  163. Multi Time sheet production (3 replies)
  164. Date plus hours excluding specific time interval (8 replies)
  165. Join and Count (7 replies)
  166. excel help........ (2 replies)
  167. Solved: Text File import - recognising values (2 replies)
  168. Sheet protection and tabs (1 replies)
  169. Solved: create custom menu w/ hyperlinks to open files (5 replies)
  170. Find and Compare (7 replies)
  171. Solved: Delete 0 length strings (8 replies)
  172. how to facilitate multiple users. (8 replies)
  173. returning the reference to a cell, not the value in the cell (2 replies)
  174. [SOLVED:] Games Behind Formula (12 replies)
  175. Loading XML file using VBA (3 replies)
  176. [SOLVED:] Userform ComboBox - Type Mismatch error in code (11 replies)
  177. Solved: Occurance Count (5 replies)
  178. Please help! I don't even know where to start. (9 replies)
  179. Solved: CSV To Sheets In Workbook Using ID Number (19 replies)
  180. Sleeper: Is UDF called from Wizard ? (6 replies)
  181. Conditional Formatting (3 replies)
  182. [SLEEPER:] Deleting by columns lastrow (4 replies)
  183. Simplifying code from excel to word (3 replies)
  184. Solved: Conditional Formating for weekend (3 replies)
  185. name box extender (2 replies)
  186. Simple simulation help (11 replies)
  187. Autonumber form but be able to save as file each time (6 replies)
  188. Solved: Hide custom CommandBar form Popup Menu (4 replies)
  189. Solved: Send email from excel (11 replies)
  190. Solved: some countif ...sum if help (2 replies)
  191. Solved: Multi value lookup (3 replies)
  192. Solved: windows scheduler and application ontime (5 replies)
  193. Solved: Now Function - convert to General format ? (4 replies)
  194. Update report filter across multiple pivot tables (6 replies)
  195. Compare two doubles (5 replies)
  196. Not able to save add-in file under different name (2 replies)
  197. Array navigation (9 replies)
  198. Solved: Delete Rows That Total 0 (2 replies)
  199. Automated formatting (4 replies)
  200. call stack question? (4 replies)
  201. Open .csv from code (3 replies)
  202. Date Modified (4 replies)
  203. Solved: ComboBox - SetFocus ? (7 replies)
  204. NUMBERS HELP (8 replies)
  205. Solved: TIMER (7 replies)
  206. Determining the working days (6 replies)
  207. autonumber depends upon start date (5 replies)
  208. Need EASY help with a plot (9 replies)
  209. Auto width of a listbox on a userform? (6 replies)
  210. SQL using Excel VBA & passed to Access doesn't run, runs directly in Access! (1 replies)
  211. Solved: Removing items from menu bar (3 replies)
  212. Userform submit to Worsheet (Subscript out of range) (6 replies)
  213. parent window refresh (4 replies)
  214. sum by cell color (1 replies)
  215. VBA findAll Copy & Paste (12 replies)
  216. Path finder (0 replies)
  217. Solved: select (3 replies)
  218. Select Previously Edited Cell (2 replies)
  219. manipulate two sheets (10 replies)
  220. Excel VBA beginners exercise (1 replies)
  221. Looping through cells and move sheets from file in folder. (6 replies)
  222. Solved: Stopping a file from being opened (4 replies)
  223. [SOLVED:] Vba Replace Function (4 replies)
  224. Solved: macro help (4 replies)
  225. Search / Find - across sheets - find multiple instances (4 replies)
  226. Excel, Date find issue (1 replies)
  227. Solved: Retrieving comments from a worksheet (2 replies)
  228. Regular expression to find negative number (4 replies)
  229. Charting Question with Line and Scatter (4 replies)
  230. utomatically close the shared spreadsheet (0 replies)
  231. Not delete or move an excel file (9 replies)
  232. Multiple fonts in excel forms textbox (4 replies)
  233. Graduated Cell Colour in Excel 2003 (5 replies)
  234. Solved: Query within Excel to SQL server with VBA Code (4 replies)
  235. Need Help With a User Form (20 replies)
  236. macro to conditonal format and negative numbers (2 replies)
  237. Weird Add-in Error (3 replies)
  238. Dimension x number of arrays based on user input (8 replies)
  239. Solved: Code works as Sub but not as a Function! (7 replies)
  240. Solved: conditional formatting (4 replies)
  241. Solved: Count the same items in a column (12 replies)
  242. Solved: Update an excel sheet, by loading from an object (2 replies)
  243. Prevent / Disable Sort function ? (1 replies)
  244. Custom Messaging with Mouseover (0 replies)
  245. Find "Hard Coded" cells? (1 replies)
  246. Solved: TIMER SCALE IN EXCEL (3 replies)
  247. Create New Macro Using VBA (8 replies)
  248. Error in the creation of multiple PivotCharts (1 replies)
  249. Find duplicate cells in a column and contitionally delete the dupes (7 replies)
  250. Extended Conditional Formatting (1 replies)