PDA

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