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:] VBA to create Table of Content but EXCLUDE xlSheetHidden andxlSheetVeryHidden (2 replies)
  2. Check a list of names, if a worksheet exists move on, if not, create one (8 replies)
  3. Excel Module to find() and assign variables (3 replies)
  4. [SOLVED:] Colour cell in column F if any value in cloumn J (2 replies)
  5. How Do I Get An Excel Sheet That Validates And Then Emails? (4 replies)
  6. Copy range and paste depending on the selected checkbox (1 replies)
  7. Macro becoming slower (25 replies)
  8. VBA Code For Appending to the text file (5 replies)
  9. Include theme colors in an add-in (10 replies)
  10. Consolidate worksheets with specific requirements (4 replies)
  11. [SOLVED:] delay in a macro? (2 replies)
  12. How to shade rows with three different colours (9 replies)
  13. [SOLVED:] Banding Formats (2 replies)
  14. Need VBA help duplicating certain rows and manipulating data on these rows (1 replies)
  15. run Word script from Excel with multiple open documents (5 replies)
  16. [SOLVED:] Class Modules - a few questions (5 replies)
  17. copy and pasting pivot graphs in different worksheets into a new worksheet (0 replies)
  18. Compare two workbooks and generate a report for the differences. (1 replies)
  19. [SOLVED:] Help Using Excel Month Function (3 replies)
  20. [SOLVED:] Lookup Value in Range for an If Statement (2 replies)
  21. get Zip codes from web based on address in cell excel VBA (2 replies)
  22. Automatically populating data when a certain column is filled (17 replies)
  23. vlookup query using VBA (19 replies)
  24. Userform Populated with range from another excel file (4 replies)
  25. Consulting work recommendations (1 replies)
  26. How to fill down to a certain length and delete everything before it (3 replies)
  27. Close Workbook Only if Completed (3 replies)
  28. InputBox OK and Cancel Button Problem (4 replies)
  29. How to paste data into next available blank row (3 replies)
  30. [SOLVED:] More precise number formats with "$" symbol? (9 replies)
  31. Can anybody help me? (12 replies)
  32. Copy row from one sheet to other sheet (1 replies)
  33. [SOLVED:] Find word insert formula (5 replies)
  34. Find match copy paste from another closed workbook (5 replies)
  35. [SOLVED:] Row deletion..!! Reverse case... (23 replies)
  36. [SOLVED:] macro to take information from. xml file and put it in. xls file (7 replies)
  37. Run time error 1004 Select methof of Worksheet class failed (6 replies)
  38. [SOLVED:] Find PN then trim all spaces (2 replies)
  39. destination name problem when error handeling... Please Help!!! (3 replies)
  40. Combining Workbooks with different file extensions (3 replies)
  41. Using a percentage in VBA (4 replies)
  42. VBA to copy from a web browser (2 replies)
  43. Sort not working anymore (2 replies)
  44. formula using VBA (5 replies)
  45. VB, Input Boxes and Printer Selection (2 replies)
  46. Add blank rows to fill a page (3 replies)
  47. Beginner's Question on IF function in VBA (4 replies)
  48. Creating Dynamic Named Ranges for Dependent Data Validation Lists (5 replies)
  49. select and delete row based on a cell's value (3 replies)
  50. problem with VBA when I open Excel automatically (2 replies)
  51. I Need assistance with popup calendar macro in excel 2010 (0 replies)
  52. How do I set .MarkerBackgroundColor in a chart to a ThemeColor with TintAndShade? (3 replies)
  53. Create a Loop Until using VBA (12 replies)
  54. EXCEL 2010: Macro is not working (3 replies)
  55. How to make all MsgBox and InputBox pop up in the same part of the screen. (4 replies)
  56. [SOLVED:] cmBox.setfocus doesn't give cmBox focus. Why? (24 replies)
  57. If function wont distinguish between letters and numbers. (5 replies)
  58. Compare and Copy (2 replies)
  59. [SOLVED:] VBA Stacking cells on top of each other (4 replies)
  60. Array Into Outlook Messages (3 replies)
  61. How to Convert XLM Files to Excel VBA Workbook/File? (7 replies)
  62. programmatically add reference and module in one macro (5 replies)
  63. Copy files listed in Excel from one directory to another...? (2 replies)
  64. [SOLVED:] Clearcontents method of range class failed (6 replies)
  65. [SOLVED:] Conditioning the names in a cell (6 replies)
  66. [SOLVED:] loop thru rows and populate a cell based on another cell's content (1 replies)
  67. need help with VBA for copying highlighted rows (2 replies)
  68. [SOLVED:] Listing Conditional Formatting on Separate Sheet or Workbook (23 replies)
  69. [SOLVED:] Can a Add-in detect when you save a different workbook? (3 replies)
  70. Create separate word docs with data from xls (6 replies)
  71. [SOLVED:] Date format issues with date picker on form (2 replies)
  72. [SOLVED:] Search rows on one or more criteria (2 replies)
  73. Help creating lotus email with attachments from excel look up list (1 replies)
  74. Anyone Used LockXLS? (3 replies)
  75. vlookup question (13 replies)
  76. [SOLVED:] Print two different worksheets from two files within one folder (5 replies)
  77. Selected Slicer Value to Populate Cell (7 replies)
  78. Run macro in all worksheets (2 replies)
  79. Need help editing this macro code (1 replies)
  80. Output From and to document numbers and missing number for each branch in given range (12 replies)
  81. switching between running Programs or Alt+tab (2 replies)
  82. Using multiple checkboxes to hide and show specific columns Excel 2010 (1 replies)
  83. Excel 2007 to Excel 2010 Incompatibility (2 replies)
  84. Need a macros that read a range of cells, determine low value, then do something else (9 replies)
  85. hyphen in code (6 replies)
  86. [SOLVED:] Stability Issues in VBA macro (8 replies)
  87. custom views with a protected worksheet (4 replies)
  88. Recore new macro tool - automatically start on opening (2 replies)
  89. [SOLVED:] Can you clear ALL .OnKey assignments at once? (3 replies)
  90. [SOLVED:] Select, Zip, and Email Excel files (4 replies)
  91. Mid() mismatch (2 replies)
  92. Merging Data From Workbooks macro (8 replies)
  93. [SOLVED:] how do I change file extension on VBA that I already use (3 replies)
  94. VBA Yearly Extract (6 replies)
  95. [SOLVED:] Can this be done in a formula? (2 replies)
  96. Exclude specific worksheet from existing code (10 replies)
  97. [SOLVED:] When is data removed from the clipboard? Can I avoid copying a range for each paste? (4 replies)
  98. [SOLVED:] AutoFilter criteria help (2 replies)
  99. Calculating Difference of Workdays (1 replies)
  100. Downloading an Excel file from a website (3 replies)
  101. [SOLVED:] Application.FileSearch in Office 2010 (4 replies)
  102. [SOLVED:] VBA Multiple Sheet Formatting (5 replies)
  103. Macro todelete a chart if it has zero values using VBA (1 replies)
  104. How to append Signature File in Lotus Notes?? (0 replies)
  105. [SOLVED:] Separating piece of file names into three different column (10 replies)
  106. Sleeper: Ignore If statement if condition equates to error (1 replies)
  107. Text File Import w/ Variable File Name (1 replies)
  108. SFTP Error (9 replies)
  109. VBA Code De-bugging in 2010 excel (7 replies)
  110. filter pivot tables with one pivot table with multiple value selection (3 replies)
  111. Help with a search and copy funktion (3 replies)
  112. [SOLVED:] Beginner: Application.Caller for a shape (2 replies)
  113. [SOLVED:] I need help merging workbooks (1 worksheet in each) into a summary workbook. (10 replies)
  114. RegEx Newbie (3 replies)
  115. [SOLVED:] Importing share price data (open, high, low, close & volume) from website (5 replies)
  116. return a value into a vlookup cell (1 replies)
  117. [SOLVED:] Searching multiple columns and returns the values in excel vba (7 replies)
  118. Getting data from web (3 replies)
  119. [SOLVED:] Help to duplicate a range on one tab to another multiple times based on a cell value (4 replies)
  120. Carry text formatting between chart titles (1 replies)
  121. [SOLVED:] formulas business days (automatic list) (2 replies)
  122. [SOLVED:] FileSearch VBA error - please help! (13 replies)
  123. Hyperlinks in a body of a Task (2 replies)
  124. [SOLVED:] Return data not duplicated via formula? (7 replies)
  125. Calculate Average Handling Time, without a timer?? (10 replies)
  126. 2007 Menu Issue (1 replies)
  127. Need Help with Error Message (1 replies)
  128. Semi-Generic Bar charts (2 replies)
  129. Help big project due (6 replies)
  130. help with VBA to classify and highlight row based on value of cell (4 replies)
  131. help with VBA to classify and highlight row based on value of cell (1 replies)
  132. help with VBA to classify and highlight row based on value of cell (11 replies)
  133. Replace Cell Ref in Formula with Value (1 replies)
  134. [SOLVED:] Start Command Button from different sheet (2 replies)
  135. calculate 2 datetime and returning to days and hours (3 replies)
  136. Consolidation of 5 worksheets into a single master sheet (2 replies)
  137. VBA to N-DS (0 replies)
  138. Set Tab Order (4 replies)
  139. VBA code to list all folder names in excel (7 replies)
  140. Excel to Outlook help (1 replies)
  141. VBA code to identify folder based on folder name given in a excel sheet (2 replies)
  142. VBE I/O Errors, Out of Memory, and crashing of Excel due to duplicate VB code (3 replies)
  143. [SOLVED:] VBA MACRO CODE FOR GROUPING THE DATA BASED ON 2 HOURS TIME... (2 replies)
  144. VBA errors (9 replies)
  145. VBA code to sum cells based on text in a cell in the same row but different column (7 replies)
  146. [SOLVED:] Having problem with autofilter vba (10 replies)
  147. [SOLVED:] Countifs syntax (beginner question) (1 replies)
  148. [SOLVED:] How to show percentages from multiple cells in the caption for one.. userform button (2 replies)
  149. Use IF or a VBA to check multiple fields and display specific text in a cell? (1 replies)
  150. [SOLVED:] Reading text files without .txt extensions (3 replies)
  151. [SOLVED:] Turn first and last names around and remove middle initial (11 replies)
  152. [SOLVED:] Conditional formating using relative references (3 replies)
  153. Selected Sheet Range copy One after One! (2 replies)
  154. Excel Macro VBA capture dynamic column (3 replies)
  155. [SOLVED:] Countifs syntax and use, beginner question (4 replies)
  156. Get Word VBA macro variables passed back to parent Excel macro that called it (2 replies)
  157. [SOLVED:] Using Functions in VBA to bring a value to a variable without using the worksheet (10 replies)
  158. Code to identify the start of an event and then report that time - multiple columns (40 replies)
  159. VBA code to add a line immediately before a footer. (2 replies)
  160. [SOLVED:] If a cell contains #N/A then copy paste end of row (3 replies)
  161. ListView at runtime (3 replies)
  162. [SOLVED:] VBA MACRO CODE FOR getting sheet names at once in multiple sheets (6 replies)
  163. Change graph source data by vba (1 replies)
  164. Excel VBA to open a website and search for specific words in search box (22 replies)
  165. Find data from other workbook-Copy All column on row (2 replies)
  166. Working with dates, ranges, and arrays (5 replies)
  167. OLEObjects Inside UserForm (10 replies)
  168. [SOLVED:] Can't find out my mistake using a variable (3 replies)
  169. Excel form to save data in Access (4 replies)
  170. [SOLVED:] Excel data to Word with images (16 replies)
  171. Opening CSV files disables / uninstalls add-ins (7 replies)
  172. VBA code for extracting three specific number patterns (8 replies)
  173. Remove duplicates on three criteria (22 replies)
  174. Moving highlight scroll bar (8 replies)
  175. [SOLVED:] Help with For..Next Loop (4 replies)
  176. Hide rows based on results of a drop down box on another sheet. (4 replies)
  177. Excel Macro Code Crashing (10 replies)
  178. [SOLVED:] Some explanation requested on converting string to double. (3 replies)
  179. Automatic graph generation macro (5 replies)
  180. Copy/Paste Recolored Picture with VBA (1 replies)
  181. [SOLVED:] Suddenly can't do anything in VBA ?? "Access is denied" ?? (8 replies)
  182. Update workbook (5 replies)
  183. Extract Specific Text From Middle of a String (4 replies)
  184. [SOLVED:] Chage default program to open a filetype? (16 replies)
  185. [SOLVED:] Counting conditional format colours, column by column (5 replies)
  186. How to Extract Row reference from chart series (2 replies)
  187. [SOLVED:] VBA code for tracking tracking updates in a column (2 replies)
  188. [SOLVED:] Inspecting dates of a Policy period (14 replies)
  189. Convert PDF data to Excel (5 replies)
  190. [SOLVED:] Find, copy & paste (14 replies)
  191. Adapt Colorpicker to limit selection to a few chosen colours (2 replies)
  192. Game in excell that I found. Where is the code that makes this game work (3 replies)
  193. [SOLVED:] Calculator buttons repeat very slowly (3 replies)
  194. [SOLVED:] Macro not working for partial date format conversion (3 replies)
  195. Need help with inspecting elements from website (3 replies)
  196. Are these multiple range objects or multiple names (8 replies)
  197. Lookup multiple values and compare different scenarios to get a specific result (4 replies)
  198. Need help with four basic VBA functions (10 replies)
  199. Unhide Entire Rows based on numeric value in cell (1 replies)
  200. Code duration inconsistent (4 replies)
  201. [SOLVED:] Wildcards with Replace in VBA (2 replies)
  202. [SOLVED:] Counting specific figures based on pivot table data (17 replies)
  203. [SOLVED:] Ratio being force formatted into Time (2 replies)
  204. [SOLVED:] Small Delay when showing Form (9 replies)
  205. Input date into input box on website not working correctly (3 replies)
  206. Login into intenet website not recognizing password via VBA code from excel (1 replies)
  207. PowerPoint crashes while copypasting diagrams from Excel (0 replies)
  208. [SOLVED:] Headings in formulas (4 replies)
  209. file exists or not (15 replies)
  210. Latest file name in the folder path (1 replies)
  211. Sleeper: Issues getting text into a text box on a website form (15 replies)
  212. [SOLVED:] How to use the AddComment method of the range object (4 replies)
  213. Export / Print all Charts in Workbook to PDF (3 replies)
  214. Possible to have a macro "Rewrite" another macro? (3 replies)
  215. [SOLVED:] What does it mean to click on a cell? (6 replies)
  216. macro to find modified date of file (1 replies)
  217. Need Macro to Copy and Ignore Duplicate (3 replies)
  218. [SOLVED:] Is this efficient? (4 replies)
  219. Excel functions (10 replies)
  220. 2013 Slicer Events (2 replies)
  221. [SOLVED:] Close workbook without save prompt? (3 replies)
  222. Copy cells from an open workbook to a closed workbook (1 replies)
  223. Help with code (3 replies)
  224. Macro for inserting new rows conditionally. (7 replies)
  225. Import Sharepoint list into Excel (0 replies)
  226. Setting a timeout for Excel workbook (10 replies)
  227. [SOLVED:] Lookup up formula (4 replies)
  228. Check If Files In A Folder Are Open Without Knowing Name/File Type (6 replies)
  229. Replace All fires WS_Change for every cell (27 replies)
  230. [SOLVED:] Calling custom class method through variable (6 replies)
  231. [SOLVED:] Formula Q: referencing first column number that meets specific criteria (6 replies)
  232. Sleeper: Create VBA Function from VBA Macro - Inverse of Matrix in Excel VBA (7 replies)
  233. To obtain the coordinates (2 replies)
  234. IE.navigate not working on VPN (2 replies)
  235. Copy and Paste if Value changes (7 replies)
  236. [SOLVED:] Rank/ Sequence of Repetition (1 replies)
  237. Problem with ProgressBar (15 replies)
  238. count numbers that are in two sets of numbers (3 replies)
  239. VBA / Excel / Formula / Examples (1 replies)
  240. Annual Time Sheet (including flexi/TOIL) - Enter Negative Time/hours (6 replies)
  241. Utilizing Stored procedure parameters in VBA (20 replies)
  242. VBA Help Needed with Dynamic Sum Formula (14 replies)
  243. [SOLVED:] FileSearch Macro error (11 replies)
  244. [SOLVED:] Excel Crashes when Saving workbook (14 replies)
  245. [SOLVED:] VBA MsgBox Width in WIN7 (9 replies)
  246. [SOLVED:] Delete duplicate rows Excel 2003 (3 replies)
  247. VBA Help please (Novice) (7 replies)
  248. [SOLVED:] De-Duplication & Merge with multiple criteria (4 replies)
  249. Help jump Columns (3 replies)
  250. One rate sheet - multiple customers/multiple rates based on the one sheet (1 replies)