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. Not VBA - INDEX MATCH MAX DATE Question!!! :) (1 replies)
  2. Excel Graph Paper Not Measuring Correctly (0 replies)
  3. Help! (3 replies)
  4. Unique Variable Name for File (1 replies)
  5. Search string or substring from range (1 replies)
  6. Duplicate Values only on ListBox (6 replies)
  7. [SOLVED:] Loop to Cut Down on Long Code (2 replies)
  8. Insert new row in excel which is protected (11 replies)
  9. Excel VBA CDO Email (4 replies)
  10. Find copy and paste into same worksheet (9 replies)
  11. overloaded excel workbook - ETL replacement ? (1 replies)
  12. Transpose and insert a column to a row on a different sheet (14 replies)
  13. Count values in rows based on column name (1 replies)
  14. [SOLVED:] Date Lookup Problem (1 replies)
  15. find all path between any two nodes (1 replies)
  16. Paste Link is greyed out during Paste Special (3 replies)
  17. Delete Rows based on Input Box Enrty (1 replies)
  18. [SOLVED:] Copied Table Missing First Column (5 replies)
  19. How to group Files in windows explorer with VBA / VBScrip (a .bat file) (0 replies)
  20. Need assistance pls (5 replies)
  21. [SOLVED:] VBA Code to open PDF file using LastModifiedDate (19 replies)
  22. Excel vba code to iterate through list and match to total (2 replies)
  23. [SOLVED:] Analyse a subset of numeric Array only (4 replies)
  24. [SOLVED:] Select Folder and Rename Files according to list in excel using VBA (1 replies)
  25. [SOLVED:] Adding Email Addresses From Names Rages to Lotus Notes (2 replies)
  26. Required Conditional formatting (0 replies)
  27. [SOLVED:] If cell is N/A, how to replace it with the average value of the cells above and below (13 replies)
  28. Loop Format (Not Looping) (1 replies)
  29. Modify the code in the userform (0 replies)
  30. [SOLVED:] Search Replace in Text files - Loop to Next Search & Replacement (14 replies)
  31. VBA not running correctly in Excel 2016 (worked perfectly 2010) (2 replies)
  32. Excel VBA creating emails via web browser (2 replies)
  33. [SOLVED:] Finding Min and Max Times for Each Date (8 replies)
  34. Want some idea on transposing function (5 replies)
  35. [SOLVED:] Shell Command results in Runtime Error 5 (7 replies)
  36. User Form to Select Pivot Table Filters (0 replies)
  37. [SOLVED:] String || How to do selection.replace with space? (9 replies)
  38. Help with Compile error: Else with out if (1 replies)
  39. If cells in a column contain a value, input text into another column. (2 replies)
  40. Split the excel based on headings (2 replies)
  41. Delete multiple files, based on cell value. (1 replies)
  42. [SOLVED:] Split the excel based on headings list (5 replies)
  43. [SOLVED:] Switch Values Between Sheets (5 replies)
  44. Help: VBA Training to pull data from online database to worksheets (0 replies)
  45. [SOLVED:] if and match formula (9 replies)
  46. BEG FOR HELP-EXCEL VBA CODE/FORMULA FOR A LIST (3 replies)
  47. Unique Random Number Generation (5 replies)
  48. VBA Script seems working at first glance, but does not.. (2 replies)
  49. Multiple similar If Statements (5 replies)
  50. Want to convert markovitz excel variance model to VBA (0 replies)
  51. Filtering on checkbox text (3 replies)
  52. run macro in workbook1 then go to workbook2 to run macro (1 replies)
  53. How do I fix this VBA Code? (1 replies)
  54. Compare Main List and Sub List, included new items in sub list to main list (0 replies)
  55. VBA website scraping - multiple link clicks to show full table (0 replies)
  56. Help with VBA Code: cell values and matching values (0 replies)
  57. [SOLVED:] Date Format Help (5 replies)
  58. Run-Time 1004 Array Copy Error Charts to PPT (1 replies)
  59. Class module for userform command buttons (2 replies)
  60. vba macro to loop through find and return search criteria (0 replies)
  61. Insert a date in a cell in one and only possible format (1 replies)
  62. Sorting a multicolumn listbox (2 replies)
  63. Transpose an array - type mismatch error (8 replies)
  64. Count unique values with three conditions (4 replies)
  65. Run Time Error 438 (1 replies)
  66. [SOLVED:] NEED HELP MODIFYING EXISTING EVENT CODE BY ADDING ANOTHER CODE RUN AS ONE CODE. (17 replies)
  67. Reading in a Text File (3 replies)
  68. [SOLVED:] Two different additions alternatively (2 replies)
  69. Copying Sheet into Master Sheet (0 replies)
  70. Using a Userform with Multilple Checkboxes to complete a Range of Cells (9 replies)
  71. Using Dynamic Ranges (without range address) inside a Formula (15 replies)
  72. Transfer data from one workbook to another (0 replies)
  73. Macro auto filter to create report pasting hidden rows. Help (5 replies)
  74. [SOLVED:] VBA remove all records from master sheet while auto refreshing and auto archival (4 replies)
  75. Compare Two Sheets and Extract Differences (4 replies)
  76. Excel VBA Email with PDF attachments (5 replies)
  77. Have a shortcut key to command bar (10 replies)
  78. [SOLVED:] Clear contents with in a range in Excel through VB (2 replies)
  79. VBA Pivot Calcfield (0 replies)
  80. Excel VBA Delete after timer (9 replies)
  81. Send Textbox Text to Array (3 replies)
  82. VBA Help - on Visible cells (3 replies)
  83. [SOLVED:] Get datetimestamp in Excel through VB (3 replies)
  84. [SOLVED:] Changing the properties of many charts (2 replies)
  85. VBA to insert text in adjacent cells (1 replies)
  86. VBA Code for highlight a row based on cell with fix column and row (2 replies)
  87. Website Auto Login - Type as Hidden - VBA (0 replies)
  88. VBA LOOKUP - How to Return Multiple columns of dynamic range? (1 replies)
  89. Modify text string all over .txt document (7 replies)
  90. "collect" data / string from another open window (which is not the excel) (0 replies)
  91. VBA code to count number of only weekdays between 2 dates (1 replies)
  92. [SOLVED:] Changing tab names dynamically (9 replies)
  93. VBA Outlook single mail instead of multiple mails to recipient (1 replies)
  94. VBA code for automatic open sheet & Update & send mail (3 replies)
  95. MACRO to record real time data (0 replies)
  96. VBA Macro help needed (3 replies)
  97. How to set "A1:A" & to variable and convert column number to letter (2 replies)
  98. write SQL table output to excel using VBA (3 replies)
  99. [SOLVED:] ODBC connection error through VBA in excel (1 replies)
  100. Need help figuring this code out! (2 replies)
  101. Update Links question (4 replies)
  102. Runtime error at #dataname = ActiveSheet.ListObject(1).Name# (3 replies)
  103. [SOLVED:] Problem writing to minimised workbook - worksheet minimised when saved (6 replies)
  104. Updating a master sheet from nightly data (16 replies)
  105. Excel VBA reuseable copy and paste below last cell (9 replies)
  106. Visual Basic code gets separated from workbook (0 replies)
  107. Loop based on text (7 replies)
  108. Dynamic drop down lists with OFFSET, LARGE, INDEX and MATCH (0 replies)
  109. creat multicharts (0 replies)
  110. add formula to first available cell column B (2 replies)
  111. Automaticall change dpi settings of windows to 125% for all devices that use the file (0 replies)
  112. [SOLVED:] maximum Value from other column (8 replies)
  113. [SOLVED:] Context menu on UserForm "reluctant" to show first time (0 replies)
  114. CONSOLIDATE 2 WORKBOOK INTO 1 MASTERSHEET (2 replies)
  115. [SOLVED:] Array resizing help (13 replies)
  116. **Macro is waiting to close the form** (0 replies)
  117. [SOLVED:] List Data Between Two Dates (9 replies)
  118. need help in writting VBA Code to save file sequentially after each loop (3 replies)
  119. Word to Excel Copy and Paste (0 replies)
  120. Calling Subroutines in VB (1 replies)
  121. [SOLVED:] VBA Code to create a folder based on cell date (1 replies)
  122. For each loop with data validation lists (3 replies)
  123. Excel Formula full update? (1 replies)
  124. Run-time error '91' Click html button (6 replies)
  125. [SOLVED:] Excel Formula full update? (2 replies)
  126. Sleeper: VBA Macro help needed to compare to column different sheet (13 replies)
  127. Efficient method of creating dashboard in Excel 2016 (2 replies)
  128. [SOLVED:] creating a access db with autonumber primary Key (1 replies)
  129. copy row, based on columns header and row color (0 replies)
  130. [SOLVED:] Create timeline in Excel with several phases on single row and only 2 input dates (0 replies)
  131. On Call Rotation Schedule with no VBA (Defined Rules) (1 replies)
  132. Request for tips and notes for code structure and style (2 replies)
  133. [SOLVED:] Maximum workbook and set to page layout view (2 replies)
  134. Date entered to next column of pivot table, reflected on master sheet (2 replies)
  135. [SOLVED:] Copy data from multiple files in a folder to master sheet (2 replies)
  136. [SOLVED:] Modules not accessing userform objects (1 replies)
  137. Code to transfer data from one workbook to another (3 replies)
  138. Not specified issue (2 replies)
  139. Display Columns in Listbox only if cells are not empty in a selected Range (1 replies)
  140. [SOLVED:] Indirect Cell references from VBA gives error (3 replies)
  141. [SOLVED:] Else problem with clicking on a row to run macro (4 replies)
  142. Help needed: looping within loops (5 replies)
  143. reduce all pdf file size which kept in folder below 100 kb excel vba code (0 replies)
  144. Monthly Payments With a Final Payment (4 replies)
  145. Foreign Language Characters (1 replies)
  146. Clean trim code explanation (1 replies)
  147. Dynamically referencing multiple named ranges (1 replies)
  148. Help !!! struggling with run-time error '-2147352571 (80020005)': Type Mismatch (9 replies)
  149. VBA copy cell data based on value in columns (15 replies)
  150. Automatic Sorting while typing (1 replies)
  151. Transposing Excel table using VBA (2 replies)
  152. Web scraping (6 replies)
  153. Shift clicking files storing filenames in an array (2 replies)
  154. VBA Pivot Table Creation Doesn't Sum all Rows (2 replies)
  155. Refer to Grouped Charts (or anything that's grouped) in VBA (5 replies)
  156. VBA VLOOKUP always returning zero. (3 replies)
  157. Insert The Created Time And Last Modified Time In Cells In Excel With VBA Code (10 replies)
  158. Setup a formula to be completed later (1 replies)
  159. Extract a word from a text in a tab (2 replies)
  160. Double Do...Loop does not work (2 replies)
  161. Get Range according multiple Listbox values (15 replies)
  162. Can't find "div class" element (10 replies)
  163. File extension issues (2 replies)
  164. Excel Online - Sharing workbook between two companies - Editing Permissions (1 replies)
  165. when drop down value is month or weeks or days, force user to enter required rows (3 replies)
  166. [SOLVED:] Bold while adding text to excel in vba (5 replies)
  167. [SOLVED:] Countif function on varying ranges (2 replies)
  168. [SOLVED:] Can't copy data from new created workbook (4 replies)
  169. Can't find DLL entry point (3 replies)
  170. Substitute a value from a Choice of multiple words in a offset cell - Randomly (2 replies)
  171. Hiding rows based on cell value - VBA (1 replies)
  172. Getting runtime error from Range object that VBA Debugger shows as "String * -1" Type (2 replies)
  173. Multi Condition Average (0 replies)
  174. Compile Error with ComboBox (1 replies)
  175. [SOLVED:] Code for Hiding Slicers on Pivot Table: Getting Error Message (2 replies)
  176. perfomance VBA with loop (2 replies)
  177. Help with VBA (2 replies)
  178. Importing CSV through PowerQuery to Excel (1 replies)
  179. vba autofilter with several search cells as a filter (2 replies)
  180. Delete entire column with duplicates in row 2 (7 replies)
  181. [SOLVED:] How to Disabled a Command AFTER the last row is inserted. (4 replies)
  182. [SOLVED:] Adding continuous Series Collections with loop (2 replies)
  183. [SOLVED:] Problem inserting formula with VBA (2 replies)
  184. QR Code system for Excel for estate inventory and sales (1 replies)
  185. Return cell values as date (0 replies)
  186. [SOLVED:] Add Dynamic Named Ranges to Each Sheet (Excel 2013) (4 replies)
  187. How to set Range based off Target Range? (5 replies)
  188. [SOLVED:] Goalseek last cell in column, changing last cell in adjacent column (5 replies)
  189. Run macro if cell has a specific value (3 replies)
  190. Updating AutoCAD Attributes with Excel (0 replies)
  191. [SOLVED:] FillDown VBA Excel doesn't work on second Worksheet (4 replies)
  192. cannot get Listbox column count property (6 replies)
  193. [SOLVED:] Different results when execute code by "F5" or "F8" (step by step). (4 replies)
  194. Merge data from multiple spreadsheets into one master sheet. (0 replies)
  195. Merge data from multiple spreadsheets into one master sheet. (1 replies)
  196. Copying Excel Tracker into Access - Endless Issues with INSERT INTO statement (1 replies)
  197. VBA syntax question for Dynamic Web Query (1 replies)
  198. how to click href using vba (0 replies)
  199. scheduled macros execute a few times VBA? (2 replies)
  200. Randomly selecting 50 cells from a range & filling with color (6 replies)
  201. Automatic calculation problem (2 replies)
  202. [SOLVED:] Need help with eisting event code to in regards to recording row of active color cell (2 replies)
  203. Control Box Data Validation won't change font size (2 replies)
  204. Control Box Data Validation won't change font size (0 replies)
  205. MkDir Runtime Error 76 (5 replies)
  206. PowerQuery refresh / Pivot Table refresh (4 replies)
  207. Populate and Sort a ComboBox with visible unique values from an Excel table (4 replies)
  208. Index/Match over multiple tabs (2 replies)
  209. Programmatically Add Procedure to Sheet Module (6 replies)
  210. [SOLVED:] Looping trough varibales names - is that possible (16 replies)
  211. [SOLVED:] RibbonX customization issues (XML) (6 replies)
  212. Code that will compare two files and merge the data (0 replies)
  213. Month report in excel doc (2 replies)
  214. [SOLVED:] multiple columns in a list box (2 replies)
  215. [SOLVED:] Getting The Cells to focus!!! Using FOR LOOP to find and select only the last row) (9 replies)
  216. VBA to Download documents using URLs, create a folder and save it in (3 replies)
  217. [SOLVED:] VBA - Help Needed - Macro SpeedUp (2 replies)
  218. [SOLVED:] Trying to Shorten/Simplify some Code to Make it Easier to Apply To Other Workbooks (1 replies)
  219. Trying to create an interactive UserForm (0 replies)
  220. [SOLVED:] Weird forloop behavior with worksheets (7 replies)
  221. Adjusting my working Excel -> Outlook Calendar Code to work with an exchange calendar (0 replies)
  222. [SOLVED:] Transpose Column - But Exclude Rows - Found in Array List (4 replies)
  223. [SOLVED:] Excel VLOOKUP to Google Sheets (1 replies)
  224. Sleeper: Macro to stack lists until empty (1 replies)
  225. [SOLVED:] Error 438 (11 replies)
  226. macros to search for string in cell from text files under folder & return no of count (4 replies)
  227. Struggling wth VBA, trying to specify paste destination (1 replies)
  228. Excel Crashes (2 replies)
  229. VBA Transpose Paste Loop (looping recorded Macro) (2 replies)
  230. "You've entered too many arguments for this function" (8 replies)
  231. Removing all non-numbers from the last portion of string (2 replies)
  232. [SOLVED:] Transpose multiple rows, varied length, to a single column? (5 replies)
  233. Copy range in worksheet into new workbook - input box (1 replies)
  234. [SOLVED:] UDF returning multiple values (4 replies)
  235. Help needed to edit CSV files (3 replies)
  236. Removing Conditional Formatting When Printing to PDF (5 replies)
  237. [SOLVED:] problems with copying the values of one cell to another (4 replies)
  238. [SOLVED:] Multicolum list box displays incorrect format (3 replies)
  239. Switching from one tab to another VBA (1 replies)
  240. [SOLVED:] How to turn off "activate when cell changed" while other macros change cells? (4 replies)
  241. Delete columns based on current month (0 replies)
  242. VBA - How to select range of cells based on value of 2 cells in each row (3 replies)
  243. [SOLVED:] Set Focus To A Particular Cells with OptionButton (2 replies)
  244. return only values from one column which have different values in another column (8 replies)
  245. [SOLVED:] VBA Copy Clear Paste (8 replies)
  246. Consolidate datas from workbooks to masterfile (0 replies)
  247. [SOLVED:] have cell take value of another cell when a thir cell's value is changed (0 replies)
  248. [SOLVED:] Creating consistent charts and layouts (6 replies)
  249. Run-time Error 438 (7 replies)
  250. Import CSV files in a Loop (2 replies)