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

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