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

  1. Run time Error 438
  2. [SOLVED] Modifying VBA code in multiple files
  3. Automation Error when trying to run stored procedure on SQL server
  4. Learning VBA
  5. VBA: GetObject / Copy and Past is bringing only 255 characters
  6. Find and Replace Multiple values in Excel
  9. VBA - Lock the cell based on Conditional Formatting
  10. Required VBA code to change Color of chart & also formatting
  11. [SOLVED] Any way to make this apply to a larger selection instead of just 1 cell ?
  12. [SOLVED] How to set up spreadsheet for regression analysis in Excel 2016
  13. [SOLVED] Userform with File Selector Process not working
  14. [SOLVED] How to find the top5 and bottom5 values without using large or small
  15. [SOLVED] Help for interpretation of the code
  16. [SOLVED] Please need some help to edit my macro (Copy colored words)
  17. Runtime 50290 error When trying to enter Time value in a Range
  18. Bluezone 7.1 and Excel VBA
  19. How to use arrays to filter and find information
  21. Merge few files with few sheets to one sheet
  22. [SOLVED] VBA: USE InStrRev to get file Name
  23. 64 bit excel question
  24. How to create and manage user access
  25. [SOLVED] Excell userform requiring boxes to be populated with filenames
  26. [SOLVED] VBA myFSO GetFolder path problem
  27. Replacement for PLX-DAQ Add-In
  28. Reading the XML of a workbook
  29. List box error 308
  30. [SOLVED] Possible Combination
  31. VBA - help optimise/clean up the code
  32. [SOLVED] VBA code copy and paste
  33. Code addition of rows
  34. [SOLVED] How To Show A System Tray Notification Balloon
  35. 2nd validation-How to prevent user from entering end date less than start date?
  36. Extract rows of data based on a criteria
  37. vba for shifting or arranging certain column with respect to Data1 sheet
  38. [SOLVED] If Formula with Year Function
  39. [SOLVED] Remove Duplicate Data by Specify Columns and Their Date
  40. Best way to create dynamic named ranges
  41. VBA for Slicer & Table Formatting
  42. Remove Duplicates By Making Them Unique
  43. Lock Black Colored Cells (Revised)
  44. Scatter Plot with Filter option
  45. advance filter
  46. Copy Data till Last Row and Column
  47. Pivot table changing from tabular view to compact view automatically
  48. VBA: Cross-match first two sheets and save result sheet as excel workbook.
  49. [SOLVED] Select Cells Excel VBA
  50. [SOLVED] A working macro that I need to change the search range and write location
  52. excel vba permission denied run time error 70
  53. VBA Copy Last Row into Last Row on Another Workbook
  54. loop
  55. Concatenating two ranges in MATCH function
  56. [SOLVED] How to restrict users between two dates using VBA
  57. link pivot tables to existing slicer(s) - error "invalid procedure call or argument"
  58. Simple VBA: Copy cell data from the top row in below cells (in the respective column)
  59. Anyone have any idea on this code to speed up macros
  60. [SOLVED] How to reduce file open time and screen flicker (with custom RibbonXML)
  61. vba property in lcase
  62. [SOLVED] Stop user from pressing CTRL + BREAK
  63. VBA: Match row data with below cells and fill cell with data condition
  64. What's the difference between the dims of Array ?
  65. VBA/Macro. Hashtag Generator.
  66. Dynamically Added Checkbox Is Not Shown While Clicked
  67. Data Entry VBA Form
  68. Populate single listbox merging different ranges from different sheets
  69. [SOLVED] Save file to a different folder, add to file name & change from .xlsm to .xlsx
  70. VBA to loop through an array
  71. Adjust VBA-Excel split code to combine similar tab names
  72. Adding Percentages to a Pivot Table with Calculated Item
  73. VBA dependent drop down list
  74. [SOLVED] vba Personal workbook - I dont get it
  75. VBA Lag/Delay Issue on Import Command Button
  76. [SOLVED] Hide Rows
  77. Search Characters Within String
  78. [SOLVED] Search multiple ranges for two specific above values and modify an offset
  79. [SOLVED] Copy/Paste files into new folders based on condition
  80. Copy Worksheet to a New Excel Document and SaveAs...
  81. [SOLVED] UNable to get vlookup property of worksheet function class
  82. [SOLVED] Locking Cells If Certain Values Is Selected
  83. Change Color Of Labels As Mouse Moves (Using MouseOver event)
  84. Extract FIlename (including dots) without extension
  85. Mac Office 2019 - Any different than Office 2016?
  86. Work Books Sheets copy to Multiple WorkBooks and Rename and Save
  87. vba chart series formula property
  88. [SOLVED] Excel VBA: Copy cell values to next empty row in table when row contains formulas.
  89. Allow Auto Data Entry into a locked cell.
  90. [SOLVED] 2 change events on 1 worksheet
  91. VBA File/Path Error
  92. [SOLVED] Commission Percent based on Gross Margin Percent Formula
  93. Update Data of Charts
  94. [SOLVED] Remove Duplicates keeping most recent change
  95. [SOLVED] Auto close userform when video ends
  96. [SOLVED] Copy data based on pivot table
  97. Get row number from a closed workbook
  98. Pasting and editing data formats in excel
  99. [SOLVED] Vba to save range with formulas as values if date is less than today.
  100. [SOLVED] Properties Window - Won't display (Not a Docking issue)
  101. VBA: Loop a simple calculation through a 2 dimensional array
  102. [SOLVED] VBA Copy Value Method not working
  103. [SOLVED] Pivot Table Name Changed Every time when Macro Runs
  104. How to run macro for multiple worksheets
  105. [SOLVED] Workbook_Open operates inconsistenly
  106. need help in macro to select a column
  107. [SOLVED] Copy cell range onto new tabs sorted in groups
  108. [SOLVED] filter sublist from list in another column then filter that with another criterion
  109. [SOLVED] Extracting Four Specific Data for each Row. Complex and Disorganized Raw Data.
  110. [SOLVED] Sum two dynamic totals
  111. [SOLVED] Showing & Hiding Rows based on values
  112. VBA API Macro Inconsistent
  113. Copy .CSV to .XLS and Formatting
  114. Repeat Bottom Rows on every printed page of a worksheet
  115. VBA Formula with dynamic range. Please help
  116. Conditionally copy content of adjacent cells to different worksheet
  117. Saving files using Relative Filepath Location
  118. VBA Query
  119. [SOLVED] Convert negative to positive numbers in range being copied
  120. Need Help : How to do convert 1 table to another format
  121. compare pictures
  122. Change code to search multiple terms across columns
  123. [SOLVED] Worksheet formula Offset 1 Column Left & another Cell
  124. Pop up a help text on userform after hovering the mouse for 1 sec
  125. [SOLVED] Extracting groups of Options button
  126. [SOLVED] How to draw out the WorkSheet properties?
  127. [SOLVED] If find any data on column P add CHECKED word on Column O
  128. Ribbon Toggle Buttons Issue
  129. [SOLVED] Crashing UDF - debug tips needed
  130. Help next sheet macro
  131. How to speed up a Change Event Loop
  132. Userform & scanner, won't go to the next field
  133. [SOLVED] Chartobjectsd and SeriesCollection
  134. Cell reference changes to make a change in URL
  135. VBA/macro to filter Pivot Table Filter Field
  136. Simple Loop For Selecting a Range and Replacing Values
  137. [SOLVED] Excel VBA events only working on last element of Collection
  138. Filter multiple sheets with same headers in one sheet
  139. [SOLVED] Run-Time error 9 Subscript out of range
  140. [SOLVED] Find and collate rows with repeated partial text in one column
  141. Chart generation loop issue
  142. Need copied web workbook to overwrite to the same worksheet
  143. Why can't I UPDATE the SELECTED value from the ListBox?
  144. [SOLVED] Need Help in VBA
  145. Hide current Roll based on Cell value
  146. [SOLVED] Type Mismatch
  147. [SOLVED] Explanation about a specific function
  148. [SOLVED] VBA Investment Returns - How to find last day of a month?
  149. Macro to populate all the macros to the ribbon
  150. coverting if formula to macro
  151. Split range based on total
  152. Returning a Value
  153. Daily Cash-flow Forecast Planning
  154. [SOLVED] Unable to resolve type mismatch with userform entry
  155. how to make exception when I get message of “if could not find the specified object”
  156. Copy worksheets (names, data and format) from saved data file to open active workbook
  157. [SOLVED] VBA cannot resolve type mismatch error with vlookup
  158. [SOLVED] How to make a search filter in Excel Userform that displays the output in the ListBox
  159. [SOLVED] Filling Empty Cells with Data based on Averages
  160. [SOLVED] VBA Code for Worst Month from Daily Data
  161. ByRef Array Button Click
  162. [SOLVED] Worksheet/Workbook properties
  163. [SOLVED] Trouble with CountIF Function in VBA, I think
  164. Unable to View XLS File Created in Office 365
  165. VBA Help
  166. Sum Variable types
  167. Wildcard Filter Not Working For Dates
  168. [SOLVED] Extracting Letters from the String
  169. Comparing two cell range
  170. [SOLVED] VBA Sumif in R1C1 style not working
  171. [SOLVED] Match, Find, Offset & Sum in loop not working
  172. extracting object browser information
  173. Extracting directly from a text file into excel with specific conditions in theheader
  174. [SOLVED] Renaming multiple worksheets from list
  175. [SOLVED] Excel, switching between worksheets is "jumpy"
  176. Select Rows which has specific value (but now Entire Row selection)
  177. formula
  178. [SOLVED] VBA code to unhide Unhide multiple columns based on multiple values in row
  179. [SOLVED] Obtain text between words and populate to different cell in another sheet
  180. [SOLVED] Problems with vlookup on another sheet
  182. [SOLVED] Use cell ref in table formula
  183. Search function using VBA
  184. Fisher Yates Shufflein Excel with VBA
  185. [SOLVED] VBA Matrix Operations Help Needed.
  186. Extract data from a table using two criteria variables
  187. [VBA-excel 2007] How to check if variable exist on userform
  188. VBA is Stubbornly Interpreting 10/12 as Date
  189. auto draw triangle from cell values in worksheet
  190. Code to unprotect worksheet in 2016
  191. Room reservation in sort of calendar
  192. [SOLVED] Referencing a range into formula: explanation
  193. [SOLVED] rename sheet and first row.
  194. Active Directory Bulk Check
  195. help
  196. [SOLVED] Colon as part of string in Userform Label
  197. VBA - Split/Extract data into specific worksheet with formatting
  198. Allocating amount with invoices based on FIFO method
  199. Using VBA To Conditionally Format
  200. Getting values from specific cells in a dynamic range
  201. VBA with index + match with 2 criterion issue
  202. [SOLVED] Compare rows of two sheets based on multiple columns
  203. Workbook Partial Name Match
  204. [SOLVED] join models
  205. Single Column Arrays or Vectors
  206. VBA for Date Expiry does not close WorkBook
  207. Cannot pass object to sub-procedure located in worksheet?
  208. [SOLVED] Copy Down Formulae Row (range of cells) Down to Last Row.
  209. A VBA Code which sort values, remove duplicate and vlookup
  210. [SOLVED] Define Worksheet As Public Variable
  211. [SOLVED] Split Function - Allow for variances
  213. [SOLVED] Combine rows of data in to one cell
  214. using VBA sendkeys with vmware horizon client
  215. Excel Questions on using "Switch" formula
  216. [SOLVED] How to add a single letter to the end of an growing number
  217. Same details load on multiple orders
  218. [SOLVED] How to change non-tabular data into tabular data with VBA
  219. Printing excel sheet to pdf
  220. [SOLVED] Application.Caller error for AutoShapeType 152
  221. VBA Coding Related to Data Entry Form
  222. Advance Filter : Not showing Particular Filtered Items.
  223. VBA codeperforming two functions, check column then count all columns & create tables
  224. [SOLVED] Userform unload issue
  225. [SOLVED] Setting date picker to certain columns only
  226. [SOLVED] macro to edit part of a cell contents
  227. Application.Run?
  228. Sorting Data Using Double Click on Header but multiple range
  229. Search textbox and create chart in userform
  231. vba excel auto filter total
  232. Compare two date column in different sheets, return adjacent value in matched dates
  233. Bringing together 2 sets of data
  234. Excel Macro To Combine Multiple Sheets in one only
  235. [SOLVED] Array problems ... need help
  236. Object not defined while trying to clear contents of row
  237. Unique Concatenate Values
  238. Delete button added to new row and delete row/move sheet.
  239. [SOLVED] Save specific sheets as separate workbooks
  240. [SOLVED] VBA Biweekly payments and monthly interest payments
  241. [SOLVED] How to use previous row's Beginning Balance in calculation
  242. remove line
  243. [SOLVED] coping conditional format and moving the compare cell with it
  244. find and retrieve a price from a different sheet index match - vlookup?
  245. Select a cell with target.row
  246. Select CSV file and Import - UTF-8
  247. Excel VBA MySQL
  248. Problem with like
  249. Compare the last two months and remove the color in the first Number
  250. [SOLVED] VBA to Create Data rows for Multi-Valued Columns