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 or Formula? to assign a number based on driving miles (15 replies)
  2. Add Usedrange property in the existing code (5 replies)
  3. [SOLVED:] Merging workbooks (8 replies)
  4. VBA Code/Macro Help (5 replies)
  5. Identify Font used in XLS sheet (6 replies)
  6. VBA Copy An Paste Only Copying 1st Row (7 replies)
  7. How to match index with two criterias and multiple dates? (11 replies)
  8. Macro to identify selected point in Excel chart (0 replies)
  9. Excel 2010 formula reccomendations (0 replies)
  10. VBA Copy/Paste Data Based Off ActiveX Dropdown Box (2 replies)
  11. [SOLVED:] Folders path in excel cell (10 replies)
  12. Help Creating a Custom Desktop Shortcut (0 replies)
  13. help building formula string (2 replies)
  14. [SOLVED:] Linking macro in one sheet to anothwer sheet (3 replies)
  15. [SOLVED:] Error with Find (438) (2 replies)
  16. [SOLVED:] Set powerpoint presentation opened from excel as active (2 replies)
  17. Transfer Selected Body Content from Outlook to Excel (1 replies)
  18. Advice needed (2 replies)
  19. [SOLVED:] Sending email with links disabled in sheets (11 replies)
  20. [SOLVED:] Transpose rows to columns (3 replies)
  21. [SOLVED:] Create a Copy of workbook with selected sheets (5 replies)
  22. [SOLVED:] Import Text Content From File - Stored in SubFolders - If It Matches File Name Col A (4 replies)
  23. How to express my cell range dynamically (using numbers) in VBA? (6 replies)
  24. [SOLVED:] VBA Clear contents help (3 replies)
  25. Average Function-Cannot do Copy and Drag with Quarterly Avg. Calc - Periodicity Issue (5 replies)
  26. [SOLVED:] Table editing (12 replies)
  27. Multiple lookups for string in once cell and return comma separated values (6 replies)
  28. VBA Deleting rows from specific cells based on some condition (31 replies)
  29. VBA to Delete Leading ,Trailing and Excess Spaces in Excel (2 replies)
  30. How to access Onedrive folder using macro / VBA? (0 replies)
  31. [SOLVED:] How to check if Cells has content or not (3 replies)
  32. [SOLVED:] VBA CellMovement from ActiveCell (3 replies)
  33. Help with vba (11 replies)
  34. [SOLVED:] Dynamic Table Array for Pivot Table in VBA (7 replies)
  35. Userform to Image (2 replies)
  36. VBA Loop Through Columns (8 replies)
  37. Excel VBA Queries (2 replies)
  38. How to save PP as pptx instead of ppt from Excel VBA (1 replies)
  39. VBA code to build Pivot tables in “Existing sheets”. (11 replies)
  40. [SOLVED:] [VBA] Copying cells from one sheet to another (6 replies)
  41. Return All Matching Rows On Button Press (1 replies)
  42. Sleeper: Scan barcode to two documents at the same time (0 replies)
  43. advanced filter code - subscript out of range/'Name' of object '_Worksheet' failed (3 replies)
  44. [ Excel ] drop down list with fixed area of dynamic table for user to enter data (4 replies)
  45. Breaking Powerpoint slidemaster link from Excel vba + quick macro question (6 replies)
  46. [SOLVED:] Align Row Content with cell format to Left column & Delete Blank row (12 replies)
  47. Export excel to pdf with pass (5 replies)
  48. ActiveX controls in office 2016 distort when design mode is off (1 replies)
  49. VBA Code will not search subfolders. (4 replies)
  50. Help with compare code (5 replies)
  51. Help Posting?? (9 replies)
  52. [SOLVED:] Finding Last Column with CF Format - Paste Previous 6 columns format to Empty Column (16 replies)
  53. [SOLVED:] Import from a Number of Worksheets Listed in a Column (3 replies)
  54. vba excel macro data between two dates (9 replies)
  55. Excel to Outlook Bold Text & Include Auto Signature (3 replies)
  56. [SOLVED:] Need help restucturing VBA Macro please! (6 replies)
  57. Multiple Modes (1 replies)
  58. [SOLVED:] Need Help: Replace all Cells of a Column with its Caption, if Cells Value is "TRUE" (5 replies)
  59. [SOLVED:] Need help const a VBA Macro to record 3rd and 4th digits, place in to rght in col B (7 replies)
  60. [SOLVED:] Extracting Form Fields from Word to Excel run-time error (2 replies)
  61. Need to VBA Grouping for 2500 Rows. (8 replies)
  62. Code Randomly works - No Pattern to when it does not work. Help Please (11 replies)
  63. spread repated cells (4 replies)
  64. [SOLVED:] Excel program & left in the lurch--please help (5 replies)
  65. [SOLVED:] Stripping Line Breaks (10 replies)
  66. Help with merging workbooks (2 replies)
  67. [SOLVED:] Scrolling not working for TreeView (8 replies)
  68. [SOLVED:] AVERAGEIF Specific cells ignoring #DIV/0! (12 replies)
  69. Loop through all worksheets in chosen folder to remove duplicate rows (10 replies)
  70. Integrate multiple filesd in a specific directory to one worksheet in a separate file (1 replies)
  71. Macro to Deduct and Display Time in Userform TextBox (2 replies)
  72. [SOLVED:] VBA Coding for Averageifs that needs to dynamically adjust over 8 quarters (6 replies)
  73. Help with Count if (5 replies)
  74. Copy down formula then remove formula from where it copied with paste it as value (6 replies)
  75. listobox remove item erorr (2 replies)
  76. [SOLVED:] Copying & Pasting Values on Same Sheet to New Table - Pasting Issues... (8 replies)
  77. VBA to Retrieve Information from Multiple Workbooks (0 replies)
  78. query close problem (1 replies)
  79. [SOLVED:] Multiple Lookup Criteria - Help Required (4 replies)
  80. [SOLVED:] Transposing each set of 22 items (all from the same column) into rows (11 replies)
  81. Help Converting Early Binding to Late Binding VBA Code (5 replies)
  82. Refine code to combine multiple CSV files into single workbook (7 replies)
  83. [SOLVED:] Search Matched File Names in Col A - Import the Text in Col B (4 replies)
  84. [SOLVED:] sorting data by cell value (2 replies)
  85. [SOLVED:] Filtered List - loop through only counting "visible" rows based on Criteria (3 replies)
  86. Close excel file if open (2 replies)
  87. Sleeper: VBA for copy from one sheet to another (1 replies)
  88. Conditional Formatting static “Applies To:” field (0 replies)
  89. Conditional Formatting static “Applies To:” field (0 replies)
  90. How to find if a date exists within 30 days of other dates in a date range in Excel (7 replies)
  91. [SOLVED:] Create an Hyperlink if cell value and file name match (6 replies)
  92. [SOLVED:] VBA compare two columns and list cells that match and the ones that don't (6 replies)
  93. Copy And Past On To Next Empty Row (6 replies)
  94. [SOLVED:] Unload all userforms except main userform (6 replies)
  95. VBA: Pulling data from files in the folder & skipping already processed ones (2 replies)
  96. VBA to export images from cells to a folder with a specific name (MSO 2011 or 2016) (3 replies)
  97. [SOLVED:] For loop for different userform (2 replies)
  98. Data Validation List generating with VBA getting 1004 error (3 replies)
  99. VBA coding program (2 replies)
  100. infinite series for the sine using VBA command button and input boxes (3 replies)
  101. Button updates cells with Spin Button (3 replies)
  102. VBA to download Crystal Reports (0 replies)
  103. Efficient way to run sub if change via slicer is detected (0 replies)
  104. BeforeDoubleClick trouble (2 replies)
  105. [SOLVED:] Extract Word into Next Row From DataSet - From Searching WordList In Another Sheet (4 replies)
  106. [SOLVED:] Copying data to a specific location, not last available empty row (6 replies)
  107. [SOLVED:] Issue with the Auto Run Macro under Workbook Open (3 replies)
  108. unable to set the formulaarray property of the range class - IF AND (2 replies)
  109. [SOLVED:] Count Rows EntireColum one Shot in VBA CountA IsNumber, IsEmpty, Istext, HasFormulas (5 replies)
  110. VBA/Macro Help: Copy and Paste x rows above, then find and replace, repeat (1 replies)
  111. Merge similar rows... (6 replies)
  112. VBA Send Email From Excel Spreadsheet (5 replies)
  113. [SOLVED:] Loop through all rows with data not just first row (2 replies)
  114. [SOLVED:] Question about Pivot Tables and Filtering Functionality (3 replies)
  115. [SLEEPER:] Filter data to another sheet with VBA calculation (1 replies)
  116. Excel VBA text file parsing help (5 replies)
  117. [SOLVED:] Dividing a column by a range of numbers (2 replies)
  118. Disconnect Slicers without using slicer name. (1 replies)
  119. EXCEL VBA SHAPE OBJECT, BUTTON, WORKSHEET HELP (2 replies)
  120. Multiple Spreadsheet data combined into one, and then again output into one workbook (0 replies)
  121. Change cells value base on other cell value by worksheet event (2 replies)
  122. Creating two lists from Multiple Columns (5 replies)
  123. Macro Subcript Out of Range Error 9 Due to Worksheet Names have a Space (6 replies)
  124. [SOLVED:] Center text vertically inside a combo box or textbox (1 replies)
  125. Excel VBA UserForm TxtBox Calulations (4 replies)
  126. VBA dilemma - Passing Variable from Input box (1 replies)
  127. [SOLVED:] Thousands and Decimal Separator Check (9 replies)
  128. [SOLVED:] Concatenate multiple cells by vba (2 replies)
  129. Userform field changes not detected when userform invoked from userform (7 replies)
  130. [SOLVED:] Find and rename Table in Workbook if it is present (6 replies)
  131. Help Keeping a running tally (5 replies)
  132. Can files residing on a slow network cause VBA to 'skip'? (4 replies)
  133. [SOLVED:] Hyperlink to Files in Directory - Filter for Specific File Types ONLY to link to (4 replies)
  134. VBA Code to Loop, Find Missing Data and Perform Calculation (8 replies)
  135. How do I set/get a range from a certain cell to the last row in that same column (2 replies)
  136. [SOLVED:] Save Application Current States. Recall them when needed. (Rescue Workbook) (6 replies)
  137. [SLEEPER:] How to run the VB in all Excel Files (0 replies)
  138. Error VBA in Excel 64-bits (6 replies)
  139. Copying from 1 Workbook and multisheets to Another Workbook and multisheets (7 replies)
  140. Print all invoices macro (1 replies)
  141. Range SpecialCells Union LastRow (18 replies)
  142. [SOLVED:] Cant delete contents of a cell ... VBA issue (5 replies)
  143. Copy to next cell blank (2 replies)
  144. Find and rename Column Header using VBA (3 replies)
  145. Copy & Pasting in VBA (5 replies)
  146. Sum by Colour Vba clarification please (8 replies)
  147. [SOLVED:] Protect/Unprotect (2 replies)
  148. Is it possible to automatically create a "Microsoft equation" from an excel formula? (3 replies)
  149. Error 430 - C# .dll - Reference VBA (4 replies)
  150. Grab file size from URL (7 replies)
  151. [SOLVED:] VBE Line continuation for Range definition (5 replies)
  152. [SOLVED:] Lock cell after macro got runed (12 replies)
  153. VBA MS Excel MySQL Connection with ODBC (1 replies)
  154. [SOLVED:] Look up in three columns (3 replies)
  155. [SOLVED:] Application.EnableCancelKey not working (3 replies)
  156. Lost Data formatting (7 replies)
  157. Gather emails from used range in sheet (0 replies)
  158. [SOLVED:] vba macro to run multiple macros in multiple workbooks (2 replies)
  159. Help with object shape name and colour (2 replies)
  160. VBA Work Sheet As Work Book Run Time Error (7 replies)
  161. Main characters to merge with Sub-characters in record (4 replies)
  162. [SOLVED:] Count number of dates mentioned more than 10 times in a column (4 replies)
  163. Trouble with Input Box (2 replies)
  164. Data form displays incorrect date format. (1 replies)
  165. VBA - ReadProcessMemory - With a Base Adress + Pointers (9 replies)
  166. [SOLVED:] Blanks in Formula Treated as Zero's (8 replies)
  167. VBA new row based on last row and input box (4 replies)
  168. Outlook to Excel (7 replies)
  169. Dynamic hyperlink to folder Path problems (4 replies)
  170. [SOLVED:] Compare one worksheet to multiple worksheets (2 replies)
  171. [SOLVED:] What is yellow dot parameter of a shape VBA (8 replies)
  172. Translating Excel formula into VBA code (14 replies)
  173. excel workbook pulls data from another excel workbook (3 replies)
  174. Running a subroutine every half hour up to 5 times (5 replies)
  175. VBA Macros Help - NPV (3 replies)
  176. COPY FROM WORD TO EXCEL (1 replies)
  177. [SOLVED:] Macro for copying multiple cells from one worksheet to another (8 replies)
  178. [SOLVED:] Vba+Excel - Pivot tables and Dynamic range (10 replies)
  179. [SOLVED:] (PDF VBA and Excel) export cover sheet w/ a loop, attach spec sheet from local drive. (17 replies)
  180. Macro enabled file will not open in Office 365 (1 replies)
  181. [SOLVED:] Deleting rows on filter (4 replies)
  182. Help - Run-time error '9': Subscript out of range (3 replies)
  183. [SOLVED:] Save sheet - New copy - Modify code witout formulas (1 replies)
  184. Run time error '13' Type mismatch (3 replies)
  185. Run time error '13' type mismatch (2 replies)
  186. Bypass "Enable content" (2 replies)
  187. VBA : Help on Filtered Range (3 replies)
  188. Save each sheet as a text file (1 replies)
  189. timesheet Out of Hours enhanced payment values (8 replies)
  190. Trouble with pulling data from offline workbooks (2 replies)
  191. [SOLVED:] Copy/select specific row to last row (3 replies)
  192. Dynamic hyperlink in VBA (4 replies)
  193. Autofit inconsistent (5 replies)
  194. [SOLVED:] Excel VB to open an XML as read only (3 replies)
  195. why blanco lines after a copy ? (2 replies)
  196. Change macro to move rows to worksheets in all workbooks in a folder (4 replies)
  197. excel document problem (4 replies)
  198. VBA Loop problem (2 replies)
  199. Find the first cell in a column by criteria and replace with combobox value (3 replies)
  200. Web Automation (Excel+VBA) - Help checking element in table (0 replies)
  201. stop errors on a user form (2 replies)
  202. [SOLVED:] Rookie Question: Three Columns - Total, Sub-Total, Calculate Percentage...? (9 replies)
  203. [SOLVED:] getting the error "91 object variable or with block variable not set" (7 replies)
  204. how to make general range (4 replies)
  205. Formula Index, Match and Partial Match four columns (2 replies)
  206. Excel Send Rows of Data to Different Email Addresses Based upon Cell Values (2 replies)
  207. Opening A Working Book and Using Copy & Paste (1 replies)
  208. Input Box and Msg box Help (1 replies)
  209. [SOLVED:] change row format to show 0 as first symbol (4 replies)
  210. [SOLVED:] Help with formula (5 replies)
  211. Save Sheet As New Work Book (6 replies)
  212. [SOLVED:] Help with code (2 replies)
  213. Header info on excel list (8 replies)
  214. Looking For A Programmer (1 replies)
  215. Make report summary using VBA arrays (5 replies)
  216. Tracking Changes to a worksheet using VBA (2 replies)
  217. Data validation query (6 replies)
  218. [SOLVED:] Move Up or Down A Rows Using VBA (4 replies)
  219. Need to correct a VLOOKUP/ INDIRECT combo formula (6 replies)
  220. [SOLVED:] VBA to assign & then access a workbook a variable (7 replies)
  221. How to unzip files? (2 replies)
  222. compare value from notepad with value in excel (1 replies)
  223. [SOLVED:] picture not load after time sometimes (3 replies)
  224. Automatically determines what shift is working based on time (3 replies)
  225. Take a text string (user input) field and resolve/parse to use defined abbrevations (18 replies)
  226. Reformatting Images in Merged Cells (4 replies)
  227. How to extract zip files by looping through folders (5 replies)
  228. Combo Box Data Validation Macro not working (0 replies)
  229. VBA to save .xml file from selected Columns (2 replies)
  230. [SOLVED:] Reset data validation drop-down list via VBA linked button (4 replies)
  231. Highlight some of the cells in a row (3 replies)
  232. How can I do this differently and faster (9 replies)
  233. Allow copy and paste only (0 replies)
  234. Macro for Splitting Information Contained Within a Column (4 replies)
  235. [SOLVED:] Data lost when sending file as attachment (1 replies)
  236. [SOLVED:] compare workbooks version number (2 replies)
  237. Emailing Named Ranges Using VBA (6 replies)
  238. [SOLVED:] automatic E-mail using Arrays in VBA (2 replies)
  239. VBA IF STATEMENT HELP (0 replies)
  240. How to Merge/ Combine , three worksheets ? (13 replies)
  241. Reformat string (2 replies)
  242. autonumber a string within a cell (6 replies)
  243. Comparing 6 coloumn and highlighting the difference (3 replies)
  244. [SOLVED:] Expand rows automatically based on grouped rows (3 replies)
  245. Macro which auto runs when every excel workbook is opened (5 replies)
  246. save and Merge PDFs From Excel (2 replies)
  247. [SOLVED:] Search for files with ending ".csv" in a folder and work on it (5 replies)
  248. [SOLVED:] My first excel VBA project (5 replies)
  249. VBA help (0 replies)
  250. [SOLVED:] Change "Selection.CurrentRegion.Select" so macro captures cols A-Q, non-contiguous (9 replies)