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. [SOLVED:] VBA Copy Value Method not working (13 replies)
  2. VBA: Loop a simple calculation through a 2 dimensional array (1 replies)
  3. [SOLVED:] Properties Window - Won't display (Not a Docking issue) (3 replies)
  4. [SOLVED:] Vba to save range with formulas as values if date is less than today. (4 replies)
  5. Pasting and editing data formats in excel (2 replies)
  6. [SLEEPER:] Get row number from a closed workbook (17 replies)
  7. [SOLVED:] Copy data based on pivot table (3 replies)
  8. [SOLVED:] Auto close userform when video ends (5 replies)
  9. [SOLVED:] Remove Duplicates keeping most recent change (6 replies)
  10. Update Data of Charts (4 replies)
  11. [SOLVED:] Commission Percent based on Gross Margin Percent Formula (1 replies)
  12. VBA File/Path Error (5 replies)
  13. [SOLVED:] 2 change events on 1 worksheet (6 replies)
  14. Allow Auto Data Entry into a locked cell. (3 replies)
  15. [SOLVED:] Excel VBA: Copy cell values to next empty row in table when row contains formulas. (1 replies)
  16. vba chart series formula property (2 replies)
  17. Work Books Sheets copy to Multiple WorkBooks and Rename and Save (1 replies)
  18. Mac Office 2019 - Any different than Office 2016? (1 replies)
  19. Extract FIlename (including dots) without extension (1 replies)
  20. Change Color Of Labels As Mouse Moves (Using MouseOver event) (4 replies)
  21. [SOLVED:] Locking Cells If Certain Values Is Selected (1 replies)
  22. [SOLVED:] UNable to get vlookup property of worksheet function class (6 replies)
  23. Copy Worksheet to a New Excel Document and SaveAs... (4 replies)
  24. [SOLVED:] Copy/Paste files into new folders based on condition (36 replies)
  25. [SOLVED:] Search multiple ranges for two specific above values and modify an offset (8 replies)
  26. [SLEEPER:] Search Characters Within String (6 replies)
  27. [SOLVED:] Hide Rows (2 replies)
  28. VBA Lag/Delay Issue on Import Command Button (2 replies)
  29. [SOLVED:] vba Personal workbook - I dont get it (2 replies)
  30. VBA dependent drop down list (1 replies)
  31. Adding Percentages to a Pivot Table with Calculated Item (0 replies)
  32. Adjust VBA-Excel split code to combine similar tab names (4 replies)
  33. VBA to loop through an array (4 replies)
  34. [SOLVED:] Save file to a different folder, add to file name & change from .xlsm to .xlsx (4 replies)
  35. Populate single listbox merging different ranges from different sheets (7 replies)
  36. Data Entry VBA Form (3 replies)
  37. Dynamically Added Checkbox Is Not Shown While Clicked (1 replies)
  38. VBA/Macro. Hashtag Generator. (0 replies)
  39. What's the difference between the dims of Array ? (1 replies)
  40. VBA: Match row data with below cells and fill cell with data condition (0 replies)
  41. [SOLVED:] Stop user from pressing CTRL + BREAK (16 replies)
  42. vba property in lcase (2 replies)
  43. [SOLVED:] How to reduce file open time and screen flicker (with custom RibbonXML) (2 replies)
  44. Anyone have any idea on this code to speed up macros (5 replies)
  45. Simple VBA: Copy cell data from the top row in below cells (in the respective column) (0 replies)
  46. link pivot tables to existing slicer(s) - error "invalid procedure call or argument" (1 replies)
  47. Concatenating two ranges in MATCH function (6 replies)
  48. loop (4 replies)
  49. VBA Copy Last Row into Last Row on Another Workbook (7 replies)
  50. [SOLVED:] excel vba permission denied run time error 70 (5 replies)
  51. [SOLVED:] RUN ADD-IN AS PART OF MACRO (3 replies)
  52. [SOLVED:] A working macro that I need to change the search range and write location (12 replies)
  53. [SOLVED:] Select Cells Excel VBA (7 replies)
  54. VBA: Cross-match first two sheets and save result sheet as excel workbook. (7 replies)
  55. Pivot table changing from tabular view to compact view automatically (1 replies)
  56. Copy Data till Last Row and Column (2 replies)
  57. advance filter (7 replies)
  58. Scatter Plot with Filter option (0 replies)
  59. Lock Black Colored Cells (Revised) (3 replies)
  60. Remove Duplicates By Making Them Unique (3 replies)
  61. [SLEEPER:] VBA for Slicer & Table Formatting (0 replies)
  62. Best way to create dynamic named ranges (6 replies)
  63. [SOLVED:] Remove Duplicate Data by Specify Columns and Their Date (2 replies)
  64. [SOLVED:] If Formula with Year Function (2 replies)
  65. vba for shifting or arranging certain column with respect to Data1 sheet (1 replies)
  66. Extract rows of data based on a criteria (4 replies)
  67. [SOLVED:] How To Show A System Tray Notification Balloon (5 replies)
  68. Code addition of rows (3 replies)
  69. [SOLVED:] VBA code copy and paste (3 replies)
  70. VBA - help optimise/clean up the code (2 replies)
  71. [SOLVED:] Possible Combination (12 replies)
  72. List box error 308 (13 replies)
  73. Reading the XML of a workbook (3 replies)
  74. Replacement for PLX-DAQ Add-In (0 replies)
  75. [SOLVED:] VBA myFSO GetFolder path problem (2 replies)
  76. [SOLVED:] Excell userform requiring boxes to be populated with filenames (5 replies)
  77. How to create and manage user access (8 replies)
  78. 64 bit excel question (2 replies)
  79. [SOLVED:] VBA: USE InStrRev to get file Name (3 replies)
  80. [SLEEPER:] Merge few files with few sheets to one sheet (0 replies)
  81. [SOLVED:] ADDING INDICATOR ICONS TO EXCEL USERFORM (3 replies)
  82. How to use arrays to filter and find information (29 replies)
  83. Bluezone 7.1 and Excel VBA (2 replies)
  84. Runtime 50290 error When trying to enter Time value in a Range (19 replies)
  85. [SOLVED:] Please need some help to edit my macro (Copy colored words) (3 replies)
  86. [SOLVED:] Help for interpretation of the code (4 replies)
  87. [SOLVED:] How to find the top5 and bottom5 values without using large or small (7 replies)
  88. [SOLVED:] Userform with File Selector Process not working (4 replies)
  89. [SOLVED:] How to set up spreadsheet for regression analysis in Excel 2016 (32 replies)
  90. [SOLVED:] Any way to make this apply to a larger selection instead of just 1 cell ? (7 replies)
  91. Required VBA code to change Color of chart & also formatting (9 replies)
  92. VBA - Lock the cell based on Conditional Formatting (3 replies)
  93. ACTIVE X CONTROL MOVES POSITION WHEN MACRO IS RUN (4 replies)
  94. [SOLVED:] CANNOT PLACE BUTTON IN SPECIFIED LOCATION (5 replies)
  95. Find and Replace Multiple values in Excel (16 replies)
  96. VBA: GetObject / Copy and Past is bringing only 255 characters (2 replies)
  97. Learning VBA (1 replies)
  98. Automation Error when trying to run stored procedure on SQL server (0 replies)
  99. [SOLVED:] Modifying VBA code in multiple files (2 replies)
  100. Run time Error 438 (4 replies)
  101. Lock pictures so immovable (but do not want to lock objects) (3 replies)
  102. [SOLVED:] vba cell event change & call macro combination (2 replies)
  103. Legend Issue (0 replies)
  104. Array Formula - More than one wildcard in lookup (2 replies)
  105. To set Date filter on pivot via input box when opening a file (1 replies)
  106. VBA to check column I and if find data and match the same ID in column A Put Data in. (4 replies)
  107. LISTFILLRANGE COMBOBOX PROPERTY NOT WORKING (1 replies)
  108. [SOLVED:] COMBO BOX MISSING, BUT PROPERTIES EXIST (2 replies)
  109. VBA Counting instances of journeys (6 replies)
  110. [SOLVED:] Insert progressive numbers in a column but every n rows (3 replies)
  111. Lock and unlock lines in worksheet based on usrname (6 replies)
  112. Password protect and unprotect a worksheet/workbook (5 replies)
  113. Array loop (3 replies)
  114. [SOLVED:] .AdvancedFilter using an array as the criteria (2 replies)
  115. INSERT TEXT AND FORMAT AUTOSHAPE (1 replies)
  116. excel stops working and crashes when working with excel user form (2 replies)
  117. Timer/StopWatch - How do I make button turn to red and flash when I click Start? (4 replies)
  118. Display CopyFromRecordset result vertically (2 replies)
  119. Help to separate two codes and place one in a Userform Function (0 replies)
  120. Need Help Re-writing Recorded Macro (3 replies)
  121. [SOLVED:] VBA creating new folders and files (10 replies)
  122. [SOLVED:] Remove excess cells (5 replies)
  123. [SOLVED:] Msg Box Problem (4 replies)
  124. Lookup formula Corresponding value in anywhere in array (0 replies)
  125. Long if statements with numbers. (1 replies)
  126. [SOLVED:] macro or VBA code "is it possible?" (13 replies)
  127. Extract Unique List That Meets Criteria (3 replies)
  128. [SOLVED:] Set Worksheet to variable name (3 replies)
  129. VBA Row offset when dynamically changing cell value (2 replies)
  130. vba example (2 replies)
  131. Copy calculated data ranges in Sheet2 O:O to Sheet1 offset column block areas in C:C (10 replies)
  132. Copy And Paste All Rows That Match A Specific Criteria (3 replies)
  133. Allow access to certain sheets in a workbook (1 replies)
  134. Comparing two columns with empty rows but same data and delete (0 replies)
  135. How to make my combobox invisible (5 replies)
  136. Copy Paste Without Opening The .csv file/s (0 replies)
  137. [SOLVED:] Paste and End(xlRight) (2 replies)
  138. VBA Conditional Format Error 9 (3 replies)
  139. Highlight cells with inputbox (32 replies)
  140. VBA restaurant ordering form (2 replies)
  141. [SOLVED:] Sub Not Defined error when using a renamed combobox (15 replies)
  142. USERFORM WITH MULTIPLE ENTRY LINES (1 replies)
  143. ControlTip Text not showing in excel Userform (5 replies)
  144. Ignoring Error VBA (8 replies)
  145. How to rename TextBoxes on userform (5 replies)
  146. Populate a cell percentage based on amount of dates in a range of cells. (7 replies)
  147. VBA save a variable when criteria is met (5 replies)
  148. [SOLVED:] Userform instructions (3 replies)
  149. open workbook (1 replies)
  150. Move file to new folder based on cell value, create folder if not already exist (6 replies)
  151. [SOLVED:] excel macro help (3 replies)
  152. Change ActiveX Image Control from UserForm (5 replies)
  153. Formula to import and sort data from other sheet based on dates (1 replies)
  154. Getting max value from a dictionary (35 replies)
  155. [SOLVED:] Trying to return Table Column rather than Sheet Column from Find method (2 replies)
  156. VBA Dynamic array (1 replies)
  157. Help with find/replace loop. (2 replies)
  158. [SLEEPER:] Make a more complex VLOOKUP formula (3 replies)
  159. Button Click (11 replies)
  160. Count Listview subitems based on condition (8 replies)
  161. [VBA] (Challange) Match dates between two workbooks and export data (2 replies)
  162. [SOLVED:] vba userform textbox Value from date picker (Monthview) (3 replies)
  163. [SOLVED:] Having trouble performing a few tasks in VBA, possibly need a loop? (3 replies)
  164. Custom Save Button (3 replies)
  165. LISTDATA MISSING FROM COMBOBOX PROPERTIES (1 replies)
  166. Check combos values and add if not already added (4 replies)
  167. VBA COPY PASTE DYNAMIC RANGE EXCEPT HEADERS (3 replies)
  168. [SOLVED:] VBA CODE TO INSERT CHECKMARK ON ANOTHER SHEET (2 replies)
  169. [SLEEPER:] Create a List of Userforms and make check visible one's (6 replies)
  170. VBA error on clearing cells (7 replies)
  171. Fill Listview form 3 identical sheets (with same headers) (12 replies)
  172. Userform to filter ,add and edit data (0 replies)
  173. Pivot table data sorting in percentage problem (0 replies)
  174. Normalising Data in Excel with VBA (6 replies)
  175. [SOLVED:] need help on using results from formula to use in case macro (3 replies)
  176. [SOLVED:] Opening unknown File names in known Folder (2 replies)
  177. [SOLVED:] Save customrange to csv file (4 replies)
  178. Transponse each n rows + merge rows periodically (1 replies)
  179. Header/Footer Print settings optimization (0 replies)
  180. Index Match and Wildcard * (0 replies)
  181. [SOLVED:] Hide rows based on username (3 replies)
  182. Multiply VBA InputBox value by cell value derived from json API URL Web Query (2 replies)
  183. VBA Conditional Formatting (3 replies)
  184. How to get Percentage (0 replies)
  185. Macro to create detailed payment schedule using summary list of bank facilities (4 replies)
  186. Complicated VBA (1 replies)
  187. [SOLVED:] Listview specific rows conditional formatting (11 replies)
  188. VB Script (22 replies)
  189. [SOLVED:] Adding line numbers to VBE Code using MZ-Tools (5 replies)
  190. [SOLVED:] Setting Header/Footer issues (3 replies)
  191. Send a file to the dropbox with a macro (7 replies)
  192. VBA Code for numbers colors-for different format cell criteria (10 replies)
  193. Macro for a variable range sum if formula (11 replies)
  194. drag & drop merge with copy-paste-code (0 replies)
  195. execute netsh with "Run as administrator" in VBA (0 replies)
  196. copy and paste based on a value present in two sheets (0 replies)
  197. [SOLVED:] insert formula via loop including cell contents in a range (2 replies)
  198. 1004 error on delete picture on mouseover VBA (1 replies)
  199. [SOLVED:] input data from vba userform textbox to a spreadsheet cell depending on the time/date (20 replies)
  200. [SOLVED:] Visualize state of ADODB recordset in statusbar (3 replies)
  201. [SOLVED:] Display 3 donut charts based on combobox (2 replies)
  202. [SOLVED:] Excel Ribbon (3 replies)
  203. Splitting data by range (4 replies)
  204. [SOLVED:] Include 3 sheets only in filtering (6 replies)
  205. Application.FileSearch replacement (1 replies)
  206. [SOLVED:] Object variable or With block variable not set -Run-Time error 91 (3 replies)
  207. [SOLVED:] Multiple concerns with my Sheets (11 replies)
  208. [SOLVED:] If values equal zero command. (2 replies)
  209. [SOLVED:] Excel to Text File (3 replies)
  210. FORMULA TO COMBINE MULTIPLES CELLS (1 replies)
  211. [SOLVED:] SQLiteForExcel Help (1 replies)
  212. Size with Chart property of format picture in VBA (1 replies)
  213. [SOLVED:] Change ActiveCell within a selected range (1 replies)
  214. VBA to compare and update data on Master Sheet/workbook from another Sheet/workbook (2 replies)
  215. Insert symbol into text box - in the active textbox where the mouse cursor is located (3 replies)
  216. scraping vba dropdownlist (1 replies)
  217. Use of the WorksheetFunction INDEX and MATCH (3 replies)
  218. [SOLVED:] Transfer worksheet to another workbook (0 replies)
  219. Doevent and buttons (0 replies)
  220. XML substitution of values (2 replies)
  221. listbox population based on search value (7 replies)
  222. Deleting rows with specific text (10 replies)
  223. Check first five characters and replace offset (4 replies)
  224. vba add (2 replies)
  225. Create text files with file names from excel column (7 replies)
  226. Check game numbers (3 replies)
  227. vba new (2 replies)
  228. Text to Rows Macro : Subscript out of range (11 replies)
  229. Excel Won't recognise as date (mm/dd/yyyy) (3 replies)
  230. ASSIGN MULTIPLE VARIABLE FROM SINGLE VALUES IN ARRAY (7 replies)
  231. VBA in shared workbooks (1 replies)
  232. Excel.Action (0 replies)
  233. Pivot Table, Calculated Item - not working on large file (0 replies)
  234. EXCEL FORMULA NOT UPDATING CORRECTLY WHEN COPIED FROM ONE YEAR TO THE NEXT. (0 replies)
  235. Need help with my VBA Dictionary task (1 replies)
  236. VBA FOR INSERTING ROWS (3 replies)
  237. Enter a password for multiple protected work books (1 replies)
  238. HOW TO COMBINE 2 MACRO INTO 1 (0 replies)
  239. Sleeper: Images Gallery in UserForm (0 replies)
  240. VBA Nest If Statement help (1 replies)
  241. Append an order number in a text file with a string and then save (1 replies)
  242. VBA Help, Automatically entering passwords on multiple workbooks (3 replies)
  243. [SOLVED:] User Defined Function vba (4 replies)
  244. Run-time error ‘-2147467259 (80004005)’ (7 replies)
  245. [SOLVED:] VBA - Use variable from InputBox in formula? (4 replies)
  246. vba for next loop (4 replies)
  247. [SOLVED:] filtering with * as one of the multiple criteria (2 replies)
  248. Merge files in one folder to a master worksheet and update (5 replies)
  249. Extracting data from same cell in dierent workheets and files inside a folder or sub (0 replies)
  250. VBA code to click on Image button in IE (0 replies)