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

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