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 174
  1. Runtime error at #dataname = ActiveSheet.ListObject(1).Name# (3 replies)
  2. [SOLVED:] Problem writing to minimised workbook - worksheet minimised when saved (6 replies)
  3. Updating a master sheet from nightly data (16 replies)
  4. Excel VBA reuseable copy and paste below last cell (9 replies)
  5. Visual Basic code gets separated from workbook (0 replies)
  6. Loop based on text (7 replies)
  7. Dynamic drop down lists with OFFSET, LARGE, INDEX and MATCH (0 replies)
  8. creat multicharts (0 replies)
  9. add formula to first available cell column B (2 replies)
  10. Automaticall change dpi settings of windows to 125% for all devices that use the file (0 replies)
  11. [SOLVED:] maximum Value from other column (8 replies)
  12. [SOLVED:] Context menu on UserForm "reluctant" to show first time (0 replies)
  13. CONSOLIDATE 2 WORKBOOK INTO 1 MASTERSHEET (2 replies)
  14. [SOLVED:] Array resizing help (13 replies)
  15. **Macro is waiting to close the form** (0 replies)
  16. [SOLVED:] List Data Between Two Dates (9 replies)
  17. need help in writting VBA Code to save file sequentially after each loop (3 replies)
  18. Word to Excel Copy and Paste (0 replies)
  19. Calling Subroutines in VB (1 replies)
  20. [SOLVED:] VBA Code to create a folder based on cell date (1 replies)
  21. For each loop with data validation lists (3 replies)
  22. Excel Formula full update? (1 replies)
  23. Run-time error '91' Click html button (6 replies)
  24. [SOLVED:] Excel Formula full update? (2 replies)
  25. [SLEEPER:] VBA Macro help needed to compare to column different sheet (13 replies)
  26. Efficient method of creating dashboard in Excel 2016 (2 replies)
  27. [SOLVED:] creating a access db with autonumber primary Key (1 replies)
  28. copy row, based on columns header and row color (0 replies)
  29. [SOLVED:] Create timeline in Excel with several phases on single row and only 2 input dates (0 replies)
  30. On Call Rotation Schedule with no VBA (Defined Rules) (1 replies)
  31. Request for tips and notes for code structure and style (2 replies)
  32. [SOLVED:] Maximum workbook and set to page layout view (2 replies)
  33. Date entered to next column of pivot table, reflected on master sheet (2 replies)
  34. [SOLVED:] Copy data from multiple files in a folder to master sheet (2 replies)
  35. [SOLVED:] Modules not accessing userform objects (1 replies)
  36. Code to transfer data from one workbook to another (3 replies)
  37. Not specified issue (2 replies)
  38. Display Columns in Listbox only if cells are not empty in a selected Range (1 replies)
  39. [SOLVED:] Indirect Cell references from VBA gives error (3 replies)
  40. [SOLVED:] Else problem with clicking on a row to run macro (4 replies)
  41. Help needed: looping within loops (5 replies)
  42. reduce all pdf file size which kept in folder below 100 kb excel vba code (0 replies)
  43. Monthly Payments With a Final Payment (4 replies)
  44. Foreign Language Characters (1 replies)
  45. Clean trim code explanation (1 replies)
  46. Dynamically referencing multiple named ranges (1 replies)
  47. Help !!! struggling with run-time error '-2147352571 (80020005)': Type Mismatch (9 replies)
  48. VBA copy cell data based on value in columns (15 replies)
  49. Automatic Sorting while typing (1 replies)
  50. Transposing Excel table using VBA (2 replies)
  51. Web scraping (6 replies)
  52. Shift clicking files storing filenames in an array (2 replies)
  53. VBA Pivot Table Creation Doesn't Sum all Rows (2 replies)
  54. Refer to Grouped Charts (or anything that's grouped) in VBA (5 replies)
  55. VBA VLOOKUP always returning zero. (3 replies)
  56. Insert The Created Time And Last Modified Time In Cells In Excel With VBA Code (10 replies)
  57. Setup a formula to be completed later (1 replies)
  58. Extract a word from a text in a tab (2 replies)
  59. Double Do...Loop does not work (2 replies)
  60. Get Range according multiple Listbox values (15 replies)
  61. Can't find "div class" element (10 replies)
  62. File extension issues (2 replies)
  63. [SLEEPER:] Excel Online - Sharing workbook between two companies - Editing Permissions (1 replies)
  64. when drop down value is month or weeks or days, force user to enter required rows (3 replies)
  65. [SOLVED:] Bold while adding text to excel in vba (5 replies)
  66. [SOLVED:] Countif function on varying ranges (2 replies)
  67. [SOLVED:] Can't copy data from new created workbook (4 replies)
  68. Can't find DLL entry point (3 replies)
  69. Substitute a value from a Choice of multiple words in a offset cell - Randomly (2 replies)
  70. Hiding rows based on cell value - VBA (1 replies)
  71. Getting runtime error from Range object that VBA Debugger shows as "String * -1" Type (2 replies)
  72. Multi Condition Average (0 replies)
  73. Compile Error with ComboBox (1 replies)
  74. [SOLVED:] Code for Hiding Slicers on Pivot Table: Getting Error Message (2 replies)
  75. perfomance VBA with loop (2 replies)
  76. Help with VBA (2 replies)
  77. Importing CSV through PowerQuery to Excel (1 replies)
  78. vba autofilter with several search cells as a filter (2 replies)
  79. Delete entire column with duplicates in row 2 (7 replies)
  80. [SOLVED:] How to Disabled a Command AFTER the last row is inserted. (4 replies)
  81. [SOLVED:] Adding continuous Series Collections with loop (2 replies)
  82. [SOLVED:] Problem inserting formula with VBA (2 replies)
  83. QR Code system for Excel for estate inventory and sales (1 replies)
  84. Return cell values as date (0 replies)
  85. [SOLVED:] Add Dynamic Named Ranges to Each Sheet (Excel 2013) (4 replies)
  86. How to set Range based off Target Range? (5 replies)
  87. [SOLVED:] Goalseek last cell in column, changing last cell in adjacent column (5 replies)
  88. Run macro if cell has a specific value (3 replies)
  89. Updating AutoCAD Attributes with Excel (0 replies)
  90. [SOLVED:] FillDown VBA Excel doesn't work on second Worksheet (4 replies)
  91. cannot get Listbox column count property (6 replies)
  92. [SOLVED:] Different results when execute code by "F5" or "F8" (step by step). (4 replies)
  93. Merge data from multiple spreadsheets into one master sheet. (0 replies)
  94. Merge data from multiple spreadsheets into one master sheet. (1 replies)
  95. Copying Excel Tracker into Access - Endless Issues with INSERT INTO statement (1 replies)
  96. VBA syntax question for Dynamic Web Query (1 replies)
  97. how to click href using vba (0 replies)
  98. scheduled macros execute a few times VBA? (2 replies)
  99. [SOLVED:] Randomly selecting 50 cells from a range & filling with color (6 replies)
  100. Automatic calculation problem (2 replies)
  101. [SOLVED:] Need help with eisting event code to in regards to recording row of active color cell (2 replies)
  102. Control Box Data Validation won't change font size (2 replies)
  103. Control Box Data Validation won't change font size (0 replies)
  104. MkDir Runtime Error 76 (5 replies)
  105. PowerQuery refresh / Pivot Table refresh (4 replies)
  106. Populate and Sort a ComboBox with visible unique values from an Excel table (4 replies)
  107. Index/Match over multiple tabs (2 replies)
  108. Programmatically Add Procedure to Sheet Module (6 replies)
  109. [SOLVED:] Looping trough varibales names - is that possible (16 replies)
  110. [SOLVED:] RibbonX customization issues (XML) (6 replies)
  111. Code that will compare two files and merge the data (0 replies)
  112. [SLEEPER:] Month report in excel doc (2 replies)
  113. [SOLVED:] multiple columns in a list box (2 replies)
  114. [SOLVED:] Getting The Cells to focus!!! Using FOR LOOP to find and select only the last row) (9 replies)
  115. VBA to Download documents using URLs, create a folder and save it in (3 replies)
  116. [SOLVED:] VBA - Help Needed - Macro SpeedUp (2 replies)
  117. [SOLVED:] Trying to Shorten/Simplify some Code to Make it Easier to Apply To Other Workbooks (1 replies)
  118. Trying to create an interactive UserForm (0 replies)
  119. [SOLVED:] Weird forloop behavior with worksheets (7 replies)
  120. Adjusting my working Excel -> Outlook Calendar Code to work with an exchange calendar (0 replies)
  121. [SOLVED:] Transpose Column - But Exclude Rows - Found in Array List (4 replies)
  122. [SOLVED:] Excel VLOOKUP to Google Sheets (1 replies)
  123. Sleeper: Macro to stack lists until empty (1 replies)
  124. [SOLVED:] Error 438 (11 replies)
  125. macros to search for string in cell from text files under folder & return no of count (4 replies)
  126. Struggling wth VBA, trying to specify paste destination (1 replies)
  127. Excel Crashes (2 replies)
  128. VBA Transpose Paste Loop (looping recorded Macro) (2 replies)
  129. "You've entered too many arguments for this function" (8 replies)
  130. Removing all non-numbers from the last portion of string (2 replies)
  131. [SOLVED:] Transpose multiple rows, varied length, to a single column? (5 replies)
  132. Copy range in worksheet into new workbook - input box (1 replies)
  133. [SOLVED:] UDF returning multiple values (4 replies)
  134. Help needed to edit CSV files (3 replies)
  135. [SLEEPER:] Removing Conditional Formatting When Printing to PDF (5 replies)
  136. [SOLVED:] problems with copying the values of one cell to another (4 replies)
  137. [SOLVED:] Multicolum list box displays incorrect format (3 replies)
  138. [SLEEPER:] Switching from one tab to another VBA (1 replies)
  139. [SOLVED:] How to turn off "activate when cell changed" while other macros change cells? (4 replies)
  140. Delete columns based on current month (0 replies)
  141. VBA - How to select range of cells based on value of 2 cells in each row (3 replies)
  142. [SOLVED:] Set Focus To A Particular Cells with OptionButton (2 replies)
  143. return only values from one column which have different values in another column (8 replies)
  144. [SOLVED:] VBA Copy Clear Paste (8 replies)
  145. Consolidate datas from workbooks to masterfile (0 replies)
  146. [SOLVED:] have cell take value of another cell when a thir cell's value is changed (0 replies)
  147. [SOLVED:] Creating consistent charts and layouts (6 replies)
  148. Run-time Error 438 (7 replies)
  149. Import CSV files in a Loop (2 replies)
  150. [SOLVED:] Compare and replace- Long Sentences (14 replies)
  151. [SLEEPER:] DTPicker - select date, then continue automatically (2 replies)
  152. Ways to optimize VBA loop (17 replies)
  153. [SOLVED:] Error 1004 with method "Columns" - only when opening the file (2 replies)
  154. Save file to folder with variable (3 replies)
  155. [SOLVED:] How to disable "traditional" Save and Save As functionality (4 replies)
  156. [SOLVED:] Hiding Rows (3 replies)
  157. errore (1 replies)
  158. [SOLVED:] VBA - Moving files (2 replies)
  159. Custome Date Picker! Duplicate value (3 replies)
  160. Copy from worksheet to worksheet in different workbooks with IF condition (6 replies)
  161. Connect via ODBC to Access FE on remote server from Excel (0 replies)
  162. cant figure out compile error: do without loop (2 replies)
  163. [SOLVED:] Forms, Formulas and Dropdowns. Difficult (16 replies)
  164. Sum for a certain criteria (9 replies)
  165. Code for Vlook up (0 replies)
  166. [SOLVED:] Code is dropped when sheet is copied and emailed (3 replies)
  167. [SOLVED:] Open Window in 64 Bit Excel VBA 7 using Windows API (1 replies)
  168. [SOLVED:] Delete Rows in Table (2 replies)
  169. Merge two pdf files with partly same name in 2 different flders (0 replies)
  170. Add a row below an activebutton, keeping the format without resizing the button (2 replies)
  171. [SOLVED:] Random Select Rows and Copy to Next Sheet based on user input value (2 replies)
  172. Change Direction (1 replies)
  173. Copy paste with VBA (1 replies)
  174. code for the filerting and copy n pasting in another sheet (0 replies)
  175. [SOLVED:] Overflow Error in Array Assignment (20 replies)
  176. [SOLVED:] CDO Email, specific cells in the body (6 replies)
  177. [SOLVED:] Chart Title and Axis Title positioning (2 replies)
  178. [SOLVED:] Storing Previous Cell Value in Historic List (7 replies)
  179. Addins and CustomUI, OnAction to only run Subs in book? (4 replies)
  180. Text stretched in inserted word object (1 replies)
  181. [SOLVED:] Range(Cells()) and the 1004 Error (6 replies)
  182. [SLEEPER:] Looping Macro (7 replies)
  183. [SOLVED:] Generate Text Files (4 replies)
  184. [SOLVED:] Array Indexing - Please help, at a loss for words... (3 replies)
  185. Attemping to loop data/extract/compare (4 replies)
  186. How to avoid hardcoding a filepath (7 replies)
  187. [SOLVED:] HTML href cutting off URL at first space (1 replies)
  188. SSL connection to external source (0 replies)
  189. Run-time error 438: Object doesn't support this property or method (2 replies)
  190. I want to make change in data model in manage data model of powerpivot by vba code (2 replies)
  191. Finding out leaves and exits (2 replies)
  192. [SOLVED:] Excel MACRO that make variable sheets with conditional information (3 replies)
  193. [SOLVED:] Setting the width of an inserted word document (1 replies)
  194. Userform on Mac (2 replies)
  195. Hiding Quick Access Toolbar (QAT) (0 replies)
  196. VBA in Excel to search for PDF's and report if exist yes/No (4 replies)
  197. Results changing from a drop down selection - understanding VBA code (1 replies)
  198. Deleting rows which consists cell value PM and CM and remain cell value intact. (1 replies)
  199. function with paramarray help (1 replies)
  200. [SOLVED:] Code that opens a file and uses data from that file to replace data in another (13 replies)
  201. Automatic Hyperlink documents in excel workbook using a command button (6 replies)
  202. [SOLVED:] Force opening a file as a .XML (2 replies)
  203. [SOLVED:] Auto copy range data and paste on last empty row (4 replies)
  204. [SOLVED:] Help with vlookup in VBA (2 replies)
  205. [SLEEPER:] Huge working excel document (3 replies)
  206. [SOLVED:] Find row index where max value is located (8 replies)
  207. [SOLVED:] Removing end elements of an array (they are all 0) (8 replies)
  208. CommandButton button in Excel 2016 does not work (1 replies)
  209. comparing elements of 2 arrays (3 replies)
  210. [SOLVED:] Set value to variable in vba to use different sub (3 replies)
  211. [SOLVED:] Take absolute value of all array elements - Please Help! (3 replies)
  212. [SOLVED:] Match Overlap Date Range and multiple criterias (2 replies)
  213. Smart View - Connect to a Shared Database (1 replies)
  214. [SOLVED:] Ribbon customization issures (2 replies)
  215. Print Charts to pdf (2 replies)
  216. Every possible combination (0 replies)
  217. Parsen/Scripting web-pages with Excel-VBA - no refresh data (2 replies)
  218. [SOLVED:] Vba Code for sorting date (8 replies)
  219. [SLEEPER:] I like to find next small value.. (2 replies)
  220. Ribbon Control not displayed at file open (2 replies)
  221. [SOLVED:] Adding batches of serial numbers (6 replies)
  222. TextToColumns FieldInfo ignored (4 replies)
  223. [SOLVED:] VBA - uppercase of the first letter in each word, while the rest remains intact (9 replies)
  224. VBA Cells update vica-versa using VBA code - Level 100 Can somebody solve this? (5 replies)
  225. How can I find next small value(look up value) in a range? (2 replies)
  226. VBA Code->copying sheet from mutiple sheets excel into single excel with diff sheets (2 replies)
  227. macro save as (8 replies)
  228. Transferring Excel data into Word (3 replies)
  229. [SLEEPER:] VBA - inserting picture on from clipboard to userform image (0 replies)
  230. [SOLVED:] UDF to count colored cell pairs fails with #VALUE! (3 replies)
  231. Copy partial rows with criteria to new workbook identified sheet (8 replies)
  232. Catching fatal VBA errors (1 replies)
  233. [SOLVED:] Retain excel cell format when copying to word bookmark (2 replies)
  234. Excel Macro pulling data from Word 2013 form - formatting question (0 replies)
  235. [SOLVED:] Limiting Window Size to the used Column range (5 replies)
  236. Macro - Mail every worksheet using A1 as address (4 replies)
  237. Splitting data into other worksheets based on data in ROW (1 replies)
  238. compare dynamic arrays and copy data from another array into a cell in WS (2 replies)
  239. Slicer vba code (3 replies)
  240. [SOLVED:] Dashboard prepration (2 replies)
  241. Import Multiple txt files (0 replies)
  242. [SOLVED:] ForEach Loop Trouble (7 replies)
  243. VBA for Setting Min and Max Axis for Scatter Plot Graph (0 replies)
  244. Vba view active ie window and mouse over text and pull to text box (0 replies)
  245. [SOLVED:] Arrays using MMULT Function (3 replies)
  246. Upon exit excel woorkbook save charts as picture (4 replies)
  247. Split to Files - adjustment (2 replies)
  248. Compare cells (4 replies)
  249. [SLEEPER:] VBA help solving assignment (2 replies)
  250. [SOLVED:] VBA- how can i have a userform behaviours just like controltiptext? (17 replies)