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. Calendar Control in Excel VBA (2 replies)
  2. [SOLVED:] Deadline pop up reminder (2 replies)
  3. VBA to Automate Outlook Mail (0 replies)
  4. VBA Create Hyperlink when additional data is added for each row based on cell value (6 replies)
  5. [SOLVED:] Changing Font Colour (14 replies)
  6. [SOLVED:] Script to detect overlapping values based on two variables (2 replies)
  7. [SOLVED:] Help with intersect (2 replies)
  8. Copy data from another file without opening (5 replies)
  9. Copy Table Thanks and best regards (0 replies)
  10. Search files from textbox in UserForm, display result in Listbox (13 replies)
  11. AT-Sign appearing in formula inserted via VBA (3 replies)
  12. [SOLVED:] how to add range in this vba code (6 replies)
  13. [SOLVED:] Use Offset to select offset cell value (32 replies)
  14. VBA Path Query (8 replies)
  15. Help with VBA (3 replies)
  16. [SOLVED:] Help : Maxifs with criteria of any part of the cell value separated with commas (3 replies)
  17. [SOLVED:] VBA Error - Mail Merge (4 replies)
  18. Use the VBA filter (6 replies)
  19. VBA (3 replies)
  20. Auto filter in all worksheets in VBA. (18 replies)
  21. Worksheets numerically sorting (5 replies)
  22. [SOLVED:] Run-Time Error 1004: Document Not Saved (2 replies)
  23. Sleeper: Interpretation of `@` sign in the formula bar (3 replies)
  24. VBA code and VBA loop (0 replies)
  25. [SOLVED:] Delete row when Cells D,E,F are empty. (1 replies)
  26. How can I add more contour lines to a wireframe chart? (5 replies)
  27. [SOLVED:] Help : Looping and Conditional Formating (7 replies)
  28. Macro - Copy values in column if any of them changes (1 replies)
  29. [SOLVED:] If cell is empty equal value from offset(1,4) (5 replies)
  30. [SOLVED:] Sort table vertically (7 replies)
  31. Outlook Macro sorts Excel worksheet but corrupts file? (2 replies)
  32. [SOLVED:] Help : Shorten code to check multiple columns in Worksheet_Change event (6 replies)
  33. search button (2 replies)
  34. Button to Stop Number Loop Code Running (1 replies)
  35. how merge and unmerge duplictes items in listbox on userform (0 replies)
  36. How do you upload PDF? (1 replies)
  37. Imprt data from MDB file (1 replies)
  38. parsing address into separate cells (5 replies)
  39. vba que: coding for dynamic calendar; multiple drop down lists outputting to new shee (3 replies)
  40. [SOLVED:] Compare first word in Multiline and delete the whole line in a multiline cell (2 replies)
  41. Name Word File According to cell value in excel (1 replies)
  42. Automatically conjoin columns (2 replies)
  43. Add worksheet change event to all sheets during runtime (5 replies)
  44. [SOLVED:] Lookup & Color cell Red (6 replies)
  45. Concatenate columns without formula in private sub worksheet_change (16 replies)
  46. Deleting Blank Rows in VBA Code (4 replies)
  47. Making listboxes interdependent (3 replies)
  48. Filters (1 replies)
  49. Excel VB Script to Fill Values Based on Common Values in an Adjacent Cell (5 replies)
  50. How can I control the color of wires in wireframe 3-D surface chart? (2 replies)
  51. [SOLVED:] Create n number of tables based on number of days in that week (10 replies)
  52. How to webscrape using VBA querySelectorAll when selectors have data-bind in them (0 replies)
  53. [SOLVED:] Date Format Issue in the Data Received (27 replies)
  54. How to disable editing in Analysis for office (2 replies)
  55. Automatically replacing placeholders in different word templates via Excel (1 replies)
  56. [SOLVED:] Name PDF from Filter Criteria Row (3 replies)
  57. Procv (0 replies)
  58. vba command import data from web page (4 replies)
  59. Error after date: 10-10-2021 (3 replies)
  60. [SOLVED:] how to find a value and copy remark, author, row and column header names to new sheet (4 replies)
  61. [SOLVED:] Trying to add tick marks to scatter plots. (1 replies)
  62. Insert time in another column when a column containing RTD updates values (10 replies)
  63. [SOLVED:] add lines (4 replies)
  64. [SOLVED:] Finding 1 but not 10 or 100 (10 replies)
  65. [SOLVED:] Total filtered rows - Range of object Global failed (18 replies)
  66. Sleeper: Is there a faster method to find extended file properties (11 replies)
  67. [SOLVED:] Find last number in column if year matches (4 replies)
  68. Read content of a XLSX or CSV file using VBA if that is stored on an FTP-server ? (0 replies)
  69. Adding formula to excisting formulas (4 replies)
  70. [SOLVED:] Selecting one OptionButton reset the choices in another Group (1 replies)
  71. [SOLVED:] "Object variable or with block variable not set" Error on Second loop of For Loop (4 replies)
  72. [SOLVED:] VBA dynamic column names in pivot tables (4 replies)
  73. [SOLVED:] Delete worksheets with blank cell (2 replies)
  74. How to Merge two arrays with filter condition? (4 replies)
  75. [SOLVED:] Stuck with replacing character (2 replies)
  76. Count blank rows after non blank row (2 replies)
  77. Adapt code attached to normal excel sheet (0 replies)
  78. [SOLVED:] Sorting based on letter, and then on number (22 replies)
  79. Formulas or guide of simpler formulas (1 replies)
  80. Countif into VBA from teams excel (0 replies)
  81. [SOLVED:] Get out of design mode (2 replies)
  82. [SOLVED:] Exclude Sheet from Formula (5 replies)
  83. is there any macro to open temp file folder and delete temp files (5 replies)
  84. Can VBA determine the first row number of each page? (3 replies)
  85. How can I set the default font color of chart titles? (1 replies)
  86. [SOLVED:] Use a formatting cell property to count duplicate (4 replies)
  87. How to assign Xaxis limits to multiple scatter plots on the same sheet? (1 replies)
  88. How to query an open ListObject? (15 replies)
  89. Extract 10 digits number from text or any special characters (2 replies)
  90. can you set 3d models to have to same depth? excel, vba (0 replies)
  91. [SOLVED:] VBA Format Function not Formatting Numbers on Worksheet (2 replies)
  92. Block to write in cell (0 replies)
  93. MACROS &VBA BEGINNER (2 replies)
  94. unable to get match property of worksheetfunction class (2 replies)
  95. vbObjectError Not Working as Expected (33 replies)
  96. VBA Beginer -Real Estate Industry (2 replies)
  97. [SOLVED:] Excel 365 - VBA to assign a formula (6 replies)
  98. [SOLVED:] run macro on range of cells only (0 replies)
  99. loop + Add value (1 replies)
  100. Move WordArts on others Sheets with a checkbox on the active sheet? (4 replies)
  101. Formula for finding unique values (7 replies)
  102. [SOLVED:] AND Cell value A minus Cell value B divided by Cell value A > 0.1 (2 replies)
  103. Work book with on time control to close in specified time (0 replies)
  104. Stop Importing file after 'End Records' (1 replies)
  105. Google Spread Sheet Search any part of the cell and display (0 replies)
  106. Sum Cell Values Until Blank Cells With VBA (5 replies)
  107. [SOLVED:] Color Cell based off of a Simple Range. (8 replies)
  108. Copy data column from a table to another (3 replies)
  109. [SOLVED:] Help. Macro works, but Excel is not responding well after running it (1 replies)
  110. Experiencing workbook with user form keeps closing upon opening (4 replies)
  111. Reading a SharePoint list using Excel VBA (8 replies)
  112. General about VBA (2 replies)
  113. [SOLVED:] Formula Modification Help with And/OR (2 replies)
  114. How to extract a specific data in a column and parse it in another column with VBA (3 replies)
  115. Copy & Paste from 1 WB to another WB (4 replies)
  116. [SOLVED:] Getting Error when calculating date value (3 replies)
  117. [SOLVED:] Listbox Multiselect (4 replies)
  118. [SOLVED:] Resolve changed filename in Excel shortcut Target attribute (1 replies)
  119. Run-time error ‘1004’: Method ‘Name’ of object ‘_Worksheet’ failed (2 replies)
  120. Adjusting VBA module (4 replies)
  121. How to pop up message box even when editing a cell (0 replies)
  122. One OptionButton change state of another one in different group (1 replies)
  123. [SOLVED:] Transferring Wide Data to Long Data (5 replies)
  124. Combine All Data From one Worksheets in All Workbooks in a Specified Directory (0 replies)
  125. Concatenate with conditional and reference (2 replies)
  126. NumberFormat of a table column (1 replies)
  127. Add sheet and rename sheet and paste only value (4 replies)
  128. How to Run a Batch File Using VBA in Excel 2013 (11 replies)
  129. [SOLVED:] Payroll Formula Help (3 replies)
  130. [SOLVED:] Application-defined or object-defined error - Error in replicating code (9 replies)
  131. Excel version (3 replies)
  132. RAM does not get released when workbook is closed (3 replies)
  133. [SOLVED:] VBA Insert ROWs into table and continue index value based on last row (2 replies)
  134. [SOLVED:] Dynamic column Add and names (3 replies)
  135. Do not update range if cell is not empty (4 replies)
  136. [VBA] Edit and Move my diagram (2 replies)
  137. [SOLVED:] Linear Interpolation (5 replies)
  138. Extract record based on company (9 replies)
  139. [SOLVED:] UserForm Button That Loops Through Various Table Styles on the Table Design Ribbon (3 replies)
  140. [SOLVED:] Copying data to another sheet in a particular format and Auto-adjustment (2 replies)
  141. [SOLVED:] VBA Create Diagramms (1 replies)
  142. VBA to Paste Text into Ppt as Title (3 replies)
  143. VBA Addition to existing cell (0 replies)
  144. Excel UDF with IF (10 replies)
  145. vba - Sendkeys Crtl+C and clipboard (4 replies)
  146. [SOLVED:] VBA formula not working because array formula needed (10 replies)
  147. How to Bring up the Table Design Dialogbox (VBA) for the User to Select Table Designs (4 replies)
  148. How can I create product keys for VBA add-ins and store it in the system? (19 replies)
  149. [SOLVED:] Use Inputbox to Add Column in Excel Table with Multiple Criteria (4 replies)
  150. [SOLVED:] Fill in blank cells with the data listed above it (8 replies)
  151. Changing shapes in footers (0 replies)
  152. [SOLVED:] VBA to export data with altered format to a csv (10 replies)
  153. Extract Excel Outlook Attcahments (2 replies)
  154. [SOLVED:] Download files from excel multiple links (0 replies)
  155. Excel VBA to delete Email String from Picked Folder (1 replies)
  156. Text File processed into Excel (8 replies)
  157. Conditional Formatting in Listview (3 replies)
  158. complex excel formula (16 replies)
  159. [SOLVED:] why is my 'find and replace' function automatically set to look in formulas? (9 replies)
  160. For Next lop ends on x +1 (5 replies)
  161. update final sheet with data from existing sheets (2 replies)
  162. 6 columns to 6 sheets in same workbook and 6 sheets charts pasted to PowerPoint slide (0 replies)
  163. Bar charts in pivot (0 replies)
  164. Map SharePoint drive using VBA (3 replies)
  165. Listbox fill via recordset (6 replies)
  166. Select only cells with visible values (1 replies)
  167. vba userform move listbox1 item to listbox2 (2 replies)
  168. Pop up windows asks what name the folder should have (1 replies)
  169. hex to color (9 replies)
  170. [SOLVED:] Move Select Rows and Columns to Sheet 2 (19 replies)
  171. Userform needs to be "moved" to show objects. (0 replies)
  172. VBA Code to copy value in a cell and paste in at the first row of the Table (4 replies)
  173. Interact with cloud-based storage using VBA (0 replies)
  174. [SOLVED:] VBA VLOOKUP BETWEEN TWO NAMED TABLES (4 replies)
  175. [SOLVED:] Pick and Chose which Workbook(s) to Close from a UserForm (4 replies)
  176. Function that converts cell into just the value of its formula (5 replies)
  177. Spread Sheet - Automatic Reset a Cell to 0 'Zero' (6 replies)
  178. Nested IFs (4 replies)
  179. Sharepoint- persons and groups field (0 replies)
  180. How to end the last row and save the new file? (0 replies)
  181. [SOLVED:] Hide Worksheet Selection From two Different ListBox in a UserForm (2 replies)
  182. Copy data from 1 row to other Sheet (1 replies)
  183. [SOLVED:] 2 ListBox/ Can't Show Column Headers on 2nd Listbox When Sheets are Selected on 1st (2 replies)
  184. Copy data from 1 row to canvas (0 replies)
  185. vba searchble dropdown (8 replies)
  186. Macro crash when extending date range (3 replies)
  187. [SOLVED:] Fill first Empty cell in column When second column has an entry inserted (4 replies)
  188. [SOLVED:] Offset Rows (4 replies)
  189. Casting Couch (1 replies)
  190. VBA for multiple files with date - maximum values (17 replies)
  191. Help with loop and MID function (5 replies)
  192. [SOLVED:] Cumuative Sum (2 replies)
  193. [SOLVED:] VBA - Formatting Height of two Merged rows (3 replies)
  194. InsertVBComponent not working (4 replies)
  195. How to get mainserver ping response on userform (0 replies)
  196. VBA to Extract digit and text from two different columns of excel (5 replies)
  197. Drop down multi select while also changing what is shown in the cell (0 replies)
  198. Move csv file to new folder (0 replies)
  199. Can't output values to cell (3 replies)
  200. checking for duplicates when creating macro to move data into master sheet (1 replies)
  201. VBA to Hide and Show rows based on multiple ranges provided (4 replies)
  202. for loop in vba (4 replies)
  203. extract OLE image from access to file by running sql adobd from vba excel (8 replies)
  204. HIDE COLUMN BASE ON CELL VALUE OF ZERO AND 1 (4 replies)
  205. [SOLVED:] VBA to use Selection.Address in a formula (3 replies)
  206. Remember selected cells in other worksheet (7 replies)
  207. Tracking equipment run times with multiple starts/stops (3 replies)
  208. Exporting from Word Textboxes to Excel (0 replies)
  209. ODBC Refresh Connection String Error in VBA / Run Time Error 1004 (4 replies)
  210. Print a sequence of sheets (0 replies)
  211. VBA Add slide to the end of the presentation (1 replies)
  212. Printing multiple workbooks into pdf (7 replies)
  213. Using Excel to send e-mails through IBM Notes (0 replies)
  214. VBA Clipboard Statement (0 replies)
  215. VBA to loop through sheets in workbooks in a file directory and add missing columns (1 replies)
  216. variable = worksheet (=>expected identifier) (2 replies)
  217. [SOLVED:] VBA to Print the Comments of a single cell (5 replies)
  218. One PDF with Print Page Order - A variation (0 replies)
  219. [SOLVED:] Save Worksheet Tabs as Seperate PDF Files to Folder (2 replies)
  220. assistance from experts to fixing theses codes (4 replies)
  221. Using SumIF with Cell.Interior.ColorIndex on another WorkSheet (0 replies)
  222. [SOLVED:] Macro removes editing options selected when re-protecting worksheet after macro runs (1 replies)
  223. [SOLVED:] VBA To Insert A new Row with Specific formatting (4 replies)
  224. Help to filter list (18 replies)
  225. How to Declare Object Variable with Direct Memory Access? (6 replies)
  226. [SOLVED:] Take subheading and move to front of each row (8 replies)
  227. HinstancePtr vs Hwnd? (5 replies)
  228. Removing Specific Fill Colors (6 replies)
  229. VBA Code to Disable Insert Header & Footer on Ribbon (2 replies)
  230. [SOLVED:] Multiple errors in VBA trying to get HTML elements by Class & Tag (5 replies)
  231. Display succeeding column data while skipping blank cells (4 replies)
  232. Paste Excel Range into Powerpoint (2 replies)
  233. [SOLVED:] Help Required : Random Sampling of Data (65 replies)
  234. [SOLVED:] Date -Time not populating correctly (8 replies)
  235. [SOLVED:] Add between 10% to 20% random to numbers in cloumn F (6 replies)
  236. [SOLVED:] VBA Loop Control Variable Issue / Question (8 replies)
  237. VBA how do you change the thickess of a line using AddLine (1 replies)
  238. Sleeper: How to dynamically add data into a new column to the right (5 replies)
  239. [SOLVED:] ORDER OF PDF MERGING - PLEASE HELP (6 replies)
  240. [SOLVED:] VBA Code for IndexMatch Function not working without error (2 replies)
  241. Extract data from automatic pivot table (0 replies)
  242. [SOLVED:] Range("R1C1") gives error (6 replies)
  243. [SOLVED:] Help : Highlight the row basis of a cell selection and restore on selectin change (8 replies)
  244. [SOLVED:] Export to single PDF from matrix of range and sheets (15 replies)
  245. Conditional If in VBA (0 replies)
  246. Concatenate with ";" if values of 3 columns are same (14 replies)
  247. VBA Excel - Conditional Formatting in Table based on group (3 replies)
  248. VBA: ActiveSheet started spitting out 1004 out of nowhere (13 replies)
  249. To automatically create a variable number of worksheets, name them and the enter the (15 replies)
  250. RE: SAP scripts VBS loop - Help required (4 replies)