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