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. sampling -VBA code
  2. need help to edit code use values instead of coords
  3. InvalidateControl in Excel not working... not sure what I'm doing wrong
  4. Absolute Cell Reference Using Match
  5. Secondary & primary axes scaling !
  6. Change Header Name on Worksheet Table from a ListBox
  7. VBE Programming buttons in Excel
  8. Automating My Excel Project
  9. Allocation with VBA until limit value is reached
  10. Need Help with the Following Macro--Copy & Paste
  11. Iteration Until Conditions Are Met - Need VBA Code
  12. VLOOKUP
  13. [SOLVED:] Resize Code Window
  14. Show Hide ranges with button selection
  15. [SOLVED:] VBA to copy data from source to destination with unique column match
  16. Deleting rows in the middle of a table
  17. accessing data from intranet and copy pasting it into the appropriate cell
  18. [SOLVED:] Macro for numbering several levels
  19. Circularity Breaker
  20. API call, send XML
  21. [SOLVED:] Stripping certain data from left side of a string
  22. [SOLVED:] Using active cell move entire row from one table to another
  23. [SOLVED:] VBA Excel Match Sets of items in a range
  24. [SOLVED:] How to mark a post as solved
  25. [SOLVED:] Formula to find single date from multiple dates
  26. [SOLVED:] Input box Data entered need code to state you’ve entered Wrong data try again
  27. [SOLVED:] Python dictionary in VBA
  28. VBA code working on one file, giving error on another
  29. [SOLVED:] How to count unique values in a dynamic range
  30. [SOLVED:] Delete all conditional formatting and coloring conditional on specific rows
  31. [SLEEPER:] Split Workwook and save
  32. [SOLVED:] Dropdown List Copy/Paste to Excel Table on Different Worksheet But in Wrong Column
  33. [SOLVED:] remove . from the last of email
  34. From Abbreviation to full form street address Column E
  35. [SOLVED:] Need to delete any row with "Daily Ledger Bal' in the 3rd column
  36. Need VBA help for Multilevel number according to the document path
  37. [SOLVED:] Dynamically locate and copy last number in a column before #N/A error
  38. [SOLVED:] Create a working search box
  39. [SOLVED:] Copy active workbook
  40. [SOLVED:] Highlight domain
  41. Data transfer from online excel to offline excel only specfic columns
  42. [SOLVED:] return TEXT value from MID w integer results
  43. [SOLVED:] Check if Excel cell is not number
  44. Execute a function stored in text format
  45. Excel spreadsheet looks different depending on how I open the file.
  46. Create Hyperlinks based on selection and cell contents
  47. [SOLVED:] How do you get Excel VBA to realize the default properties again
  48. [SOLVED:] VBA code to replace "1" with "7:00/ 15:30"
  49. [SOLVED:] Evaluating Lat Long Equations
  50. Find and replace function (not Sub) with VBA
  51. Sleeper: Recursive folder search
  52. [SOLVED:] Formula to match information from a source sheet
  53. [SOLVED:] VLOOKUP - Multiply by a percentage if appropriate
  54. [SOLVED:] Copy file from source path in cell, to destination path in cell, and create folders
  55. [SOLVED:] condition error
  56. [SOLVED:] 'Run time error 438 Object does not support this property or method
  57. [SLEEPER:] copy rows with checkbox
  58. [SOLVED:] 'Run time error 1004 method 'range' of object'_worksheet' failed
  59. Error #Value!, vba code trinomial model, Option Put American
  60. when the checkbox is checked, something must only happen in that row
  61. [SOLVED:] problem adding 2 values ​​in 2 columns
  62. [SOLVED:] Copilot
  63. [SOLVED:] Find Small in and Array
  64. Drag & drop a file to automatically copy it to a destination folder
  65. make a table bigger at the touch of a button
  66. [SOLVED:] Finding wildcards in indexing and aggregate functions.
  67. transferring a spreadsheet but specifically which sheet
  68. [SOLVED:] Vertical progress bar with label and changing height - only "grows" downward
  69. [SOLVED:] Insert names found according row .
  70. [SOLVED:] How to connect to SQL server over the internet?
  71. how do i output an ascii text from excel and maintain proper dimensions
  72. [SOLVED:] Interpolation in excel
  73. Is chatGPT the way to go with Excel
  74. Array as variable
  75. [SOLVED:] Working with Read-Only Export - Save-As
  76. [SOLVED:] All userform controls are "not" working
  77. [SOLVED:] If Cell Contains Any Words Found in the Adjacent Cell
  78. [SOLVED:] Reading items
  79. Sleeper: Macro to select next result that an xlookup would return
  80. Create my own permanent Quick Access Data Form on a UserForm in VBA?
  81. [SOLVED:] columns to columns and rows
  82. Formula in VBA
  83. Sleeper: AdvancedFilter - Removing page
  84. Sleeper: AdvancedFilter - limited columns
  85. [SOLVED:] VBA Code to Send Email Using Excel
  86. Sleeper: 'New Outlook' Broken my VBA
  87. [SOLVED:] Trying to reference data from a column of cells in a message box
  88. Sleeper: Draw proper Bezier curves to contruct flow shapes for Sankey chart
  89. Sleeper: If and Statement based on one cell and
  90. [SOLVED:] Concatenate first 3 letters of first word, and first 3 letters of second word
  91. [SOLVED:] Switching 3 colors on Form
  92. VBA formula that creates new workbook from 1 sheet after 1 cell is updated and refres
  93. Sleeper: Ribbon Menu
  94. Sleeper: Reading serial port rs232 vba
  95. [SOLVED:] Filter function (not VBA)
  96. Sleeper: VBA Help on Excel to Web portal
  97. [SOLVED:] Standard Deviation of an array
  98. Sleeper: Payroll File--Need Help with Formula
  99. Convert Excel formula to VBA code
  100. Sleeper: Pull different numbers from independent lists efficiently
  101. [SOLVED:] Counting DataValidation Attempts
  102. Move data from Template A to template B
  103. [SOLVED:] Copy Macro based on ActiveCell.Offset(r,c)
  104. [SOLVED:] Appointments Failing to Line up correctly when more than one Appt scheduled in a day
  105. Can't position dialog
  106. [SLEEPER:] Please make my code for an active workbook
  107. Removing folder and subfolder from hyperlink path
  108. Feedback for Dashboards
  109. [SOLVED:] VBA code not work if I change the file name
  110. [SOLVED:] Error handling
  111. [SOLVED:] PowerQuery Steps to Move Data
  112. Find duplicates in combobox - get index and remove from other comboboxes.
  113. [SOLVED:] VBA Highlight consequent cells based on value from another cell with criteria
  114. [SOLVED:] Should I need a terminate initialisation subset as well?
  115. [SOLVED:] Run-time error 1004 when trying to open a VBA form
  116. [SOLVED:] Transposing data
  117. [SOLVED:] Use an Input box to select a range
  118. Automatic form creation from construction activities list
  119. Change lines in a macro with the same idea but different reordering
  120. [SOLVED:] VBA Macro. I Think I'm Close But Something Is Not Right
  121. [SOLVED:] Power Query to transpose a dataset
  122. [SOLVED:] Copy and paste vba - Full numbers come out -1
  123. [SOLVED:] Dependant cells
  124. [SOLVED:] Press button to assign the reason provided and count
  125. [SOLVED:] Excel not handling large number correctly
  126. Automatic sensitivity assignment in Excel VBA - Blocks automatic processes in VBA
  127. Switching Between Two Already Open Apps
  128. Changing excel version with macros
  129. Hide the Macro form Dialog Box
  130. Oddly slow running code, under very specific circumstances
  131. Sleeper: Need some help with arrays and loops
  132. Moving file to folder with first couple matching characters
  133. [SOLVED:] Custom Function Wtih Range in Another Sheet
  134. [SOLVED:] Counts min and max quantity of equals 'strings' based on a filter column
  135. Sleeper: Excel's Formula by Example
  136. [SOLVED:] Select row apart from a merged area
  137. Simplification of Repetative Actions on 2 sets of Different Ranges
  138. Table format to rows Macro
  139. Convert Index Match to a regular excel reference
  140. [SOLVED:] how to enable macro button for every sheet
  141. Sleeper: VBA code to un-merge cells from a Database
  142. [SOLVED:] Macro Codes for auto fit columns and rows
  143. Sleeper: Loop for copying and pasting tables
  144. Sleeper: VBA Change Line colors
  145. [SOLVED:] VBA sub - result in run-time error 9, but code looks good
  146. Adding worksheets to a Listbox
  147. [SOLVED:] Join Lines
  148. Sleeper: Change Cell's named reference via VBA
  149. How to.. Macros only running one active worksheet
  150. [SOLVED:] Existing macro to password protect sheets has stopped working
  151. [SOLVED:] Pivot table showing how a Batsman was given out
  152. [SOLVED:] Update Excel table from a one column range on a different sheet
  153. How to create a module to find missing brands and models (look through table 1, compa
  154. Sleeper: Method to show exponential growth in population
  155. circular flow diagram
  156. [SOLVED:] Incrementing value in a cell depending on clicking of a macro button
  157. [SOLVED:] Incrementing a list on clicking a macro button
  158. [SOLVED:] Help with Convert a formula
  159. [SOLVED:] VBA Hyperlink not working
  160. Command Button
  161. [SOLVED:] Summing dynamic Excel column and count
  162. [SOLVED:] Close Specific Workbooks Without Saving
  163. [SOLVED:] Saving index to a variable prior to closing the file
  164. [SOLVED:] Why does this work? Replacing IF with Text
  165. Hide unhide sheets with navigation buttons
  166. [SOLVED:] How to search text in pdf files in one folder
  167. VBA module to Macro short cut and sharing to multiple users
  168. [SOLVED:] Inserting Date Last Modified in lots of excel files without opening
  169. [SOLVED:] Macro to import historical data using web query
  170. Need help with VBA
  171. Sleeper: VBA to continuously click email hyperlink
  172. [SOLVED:] Subtracting Single and Formular values
  173. Split file with multiple sheets into new workbooks based on column value
  174. Could not find installable isam when connecting Excel 2016 to SharePoint 1016 lists
  175. Cannot find the Chrome binary
  176. VBA and Highlight function has stopped the Undo Funciton
  177. [SOLVED:] Open file with vba based on file name
  178. [SOLVED:] Excel VBA NOT LOOPING
  179. userform close when i close another excel file
  180. [SOLVED:] Help needed to find matching string from the collection.
  181. [SOLVED:] Create Named Ranges from worksheet list
  182. ActiveWorkbook.SaveAs not working with folder
  183. How to save multiple output excel in single folder in the given format
  184. Creating a macro to highlight cells in one sheet using info provided in another sheet
  185. [SOLVED:] VBA code not working
  186. Sleeper: Reset CommandButton Caption after creating PDF
  187. how to merge two VBA codes in one?
  188. VBA copies random rows to new sheet
  189. [SOLVED:] Why doesn't the macro I created work on all of my sheets.
  190. Sum of arrays
  191. Sleeper: Inserting a Row under a Specified Value
  192. [SOLVED:] Compare each Value from a Row with Values in a Range
  193. Export bespoke PDF macro
  194. Need help with the following code--To Save and Close
  195. Next Help to fix VBA please?
  196. Use Excel VBA to extract fund size data
  197. need help in looping
  198. [SOLVED:] Auto commentary function
  199. Modules and forms autoupdate
  200. Generating and populating a table based on list of values in another workbook.
  201. [SOLVED:] VBA Combination/Posibility problem with and "not equal/OR"
  202. [SOLVED:] Non-VBA question for Conditional Formatting
  203. [SLEEPER:] Row protection based on specific cell
  204. VBAcode to switch(show and hide) between 4 sum value fields on a data mod pivot table
  205. Why cannot print PDF
  206. [SOLVED:] VBA help - New row in excel with predefined data
  207. Workaround to Create a Checkbox in a table with cells(A:A)
  208. [SOLVED:] IF statment nested within VBA Code
  209. Excel Not Changing Serial Date to Formatted Date
  210. Command button to download all attachments recieved today from a specific sender.
  211. [SOLVED:] Problem with Query Filters on Excel
  212. [SOLVED:] Need help: debug/fix VBA code to create new worksheets from template and names list
  213. Excel VB Macro Help
  214. Create new column in excel when email received.
  215. Run time error 91 object variables not set
  216. Syntax issue
  217. [SOLVED:] Clearing clipboard performance
  218. [SOLVED:] VBA display pictures in a table
  219. [SOLVED:] Stuck on sorting array
  220. Looping through textboxes to copy files and send emails.
  221. [SOLVED:] dynamically call sub via string
  222. VBA User form error when saving data to a table
  223. Moving rows when cell value is changed
  224. [SOLVED:] Split Text File Into Multiple Text Files keeping the header row
  225. [SOLVED:] VBA - Search explorer for keyword and return file path
  226. [SLEEPER:] Copy data including coloured cells automatically to another sheet
  227. A1 RECTANGULAR B1 APPLY
  228. Unprotect sheet for certain users upon start up
  229. Extracting Financial Data From PDF
  230. Pull information from selected row via listbox
  231. Pulling data from another workbook and worksheet
  232. Scan and copy in same worksheet
  233. [SOLVED:] Transfer columns from comparable workbook if cell value exists
  234. [SOLVED:] Pivot table filter based on value using VBA code
  235. Macro to apply MP3 tags changes with VBA
  236. [SOLVED:] List the 2nd Tuesday of the month for the next 12 months - Calculation Error
  237. VBA dictionary concept problem
  238. Optimization of newton-raphson iterative solution with excel solver vba
  239. [SOLVED:] Return Subtotal for Table Columns
  240. [SOLVED:] VBA Code to Copy UserForm Textbox data to specific Excel sheet/cells
  241. [SOLVED:] Failed to run codes from txt file
  242. Perform basic operations basen on a cell
  243. [SOLVED:] Help with a Macro to insert a column of a fairly complicated Date/Time function
  244. [SOLVED:] VBA - Remove Duplicate rows from an entire worksheet
  245. Vba to copy range from Sheet to another and define a name
  246. help with detrended fluctuatin analysis
  247. [SOLVED:] VBA Code to call another VBA function when certain cells match a given criteria
  248. Prepare Profit and Loss Statement
  249. Converting 32-bit to 64-bit VBA code
  250. VBA - define variables for shape names & use in a loop function