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

  1. Automatic calculation problem
  2. Randomly selecting 50 cells from a range & filling with color
  3. scheduled macros execute a few times VBA?
  4. how to click href using vba
  5. VBA syntax question for Dynamic Web Query
  6. Copying Excel Tracker into Access - Endless Issues with INSERT INTO statement
  7. Merge data from multiple spreadsheets into one master sheet.
  8. Merge data from multiple spreadsheets into one master sheet.
  9. [SOLVED] Different results when execute code by "F5" or "F8" (step by step).
  10. cannot get Listbox column count property
  11. [SOLVED] FillDown VBA Excel doesn't work on second Worksheet
  12. Updating AutoCAD Attributes with Excel
  13. Run macro if cell has a specific value
  14. [SOLVED] Goalseek last cell in column, changing last cell in adjacent column
  15. How to set Range based off Target Range?
  16. [SOLVED] Add Dynamic Named Ranges to Each Sheet (Excel 2013)
  17. Return cell values as date
  18. QR Code system for Excel for estate inventory and sales
  19. [SOLVED] Problem inserting formula with VBA
  20. [SOLVED] Adding continuous Series Collections with loop
  21. [SOLVED] How to Disabled a Command AFTER the last row is inserted.
  22. Delete entire column with duplicates in row 2
  23. vba autofilter with several search cells as a filter
  24. Importing CSV through PowerQuery to Excel
  25. Help with VBA
  26. perfomance VBA with loop
  27. [SOLVED] Code for Hiding Slicers on Pivot Table: Getting Error Message
  28. Compile Error with ComboBox
  29. Multi Condition Average
  30. Getting runtime error from Range object that VBA Debugger shows as "String * -1" Type
  31. Hiding rows based on cell value - VBA
  32. Substitute a value from a Choice of multiple words in a offset cell - Randomly
  33. Can't find DLL entry point
  34. [SOLVED] Can't copy data from new created workbook
  35. [SOLVED] Countif function on varying ranges
  36. [SOLVED] Bold while adding text to excel in vba
  37. when drop down value is month or weeks or days, force user to enter required rows
  38. Excel Online - Sharing workbook between two companies - Editing Permissions
  39. File extension issues
  40. Can't find "div class" element
  41. Get Range according multiple Listbox values
  42. Double Do...Loop does not work
  43. Extract a word from a text in a tab
  44. Setup a formula to be completed later
  45. Insert The Created Time And Last Modified Time In Cells In Excel With VBA Code
  46. VBA VLOOKUP always returning zero.
  47. Refer to Grouped Charts (or anything that's grouped) in VBA
  48. VBA Pivot Table Creation Doesn't Sum all Rows
  49. Shift clicking files storing filenames in an array
  50. Web scraping
  51. Transposing Excel table using VBA
  52. Automatic Sorting while typing
  53. VBA copy cell data based on value in columns
  54. Help !!! struggling with run-time error '-2147352571 (80020005)': Type Mismatch
  55. Dynamically referencing multiple named ranges
  56. Clean trim code explanation
  57. Foreign Language Characters
  58. Monthly Payments With a Final Payment
  59. reduce all pdf file size which kept in folder below 100 kb excel vba code
  60. Help needed: looping within loops
  61. [SOLVED] Else problem with clicking on a row to run macro
  62. [SOLVED] Indirect Cell references from VBA gives error
  63. Display Columns in Listbox only if cells are not empty in a selected Range
  64. Not specified issue
  65. Code to transfer data from one workbook to another
  66. [SOLVED] Modules not accessing userform objects
  67. Change data validation to vba
  68. [SOLVED] Copy data from multiple files in a folder to master sheet
  69. Date entered to next column of pivot table, reflected on master sheet
  70. [SOLVED] Maximum workbook and set to page layout view
  71. Request for tips and notes for code structure and style
  72. On Call Rotation Schedule with no VBA (Defined Rules)
  73. [SOLVED] Create timeline in Excel with several phases on single row and only 2 input dates
  74. copy row, based on columns header and row color
  75. [SOLVED] creating a access db with autonumber primary Key
  76. Efficient method of creating dashboard in Excel 2016
  77. VBA Macro help needed to compare to column different sheet
  78. [SOLVED] Excel Formula full update?
  79. Run-time error '91' Click html button
  80. Excel Formula full update?
  81. For each loop with data validation lists
  82. [SOLVED] VBA Code to create a folder based on cell date
  83. Calling Subroutines in VB
  84. Word to Excel Copy and Paste
  85. need help in writting VBA Code to save file sequentially after each loop
  86. [SOLVED] List Data Between Two Dates
  87. **Macro is waiting to close the form**
  88. [SOLVED] Array resizing help
  90. [SOLVED] Context menu on UserForm "reluctant" to show first time
  91. [SOLVED] maximum Value from other column
  92. Automaticall change dpi settings of windows to 125% for all devices that use the file
  93. add formula to first available cell column B
  94. creat multicharts
  95. Dynamic drop down lists with OFFSET, LARGE, INDEX and MATCH
  96. Loop based on text
  97. Visual Basic code gets separated from workbook
  98. Excel VBA reuseable copy and paste below last cell
  99. Updating a master sheet from nightly data
  100. [SOLVED] Problem writing to minimised workbook - worksheet minimised when saved
  101. Runtime error at #dataname = ActiveSheet.ListObject(1).Name#
  102. Update Links question
  103. Need help figuring this code out!
  104. [SOLVED] ODBC connection error through VBA in excel
  105. write SQL table output to excel using VBA
  106. How to set "A1:A" & to variable and convert column number to letter
  107. VBA Macro help needed
  108. MACRO to record real time data
  109. VBA code for automatic open sheet & Update & send mail
  110. VBA Outlook single mail instead of multiple mails to recipient
  111. [SOLVED] Changing tab names dynamically
  112. VBA code to count number of only weekdays between 2 dates
  113. "collect" data / string from another open window (which is not the excel)
  114. Modify text string all over .txt document
  115. VBA LOOKUP - How to Return Multiple columns of dynamic range?
  116. Website Auto Login - Type as Hidden - VBA
  117. VBA Code for highlight a row based on cell with fix column and row
  118. VBA to insert text in adjacent cells
  119. [SOLVED] Changing the properties of many charts
  120. [SOLVED] Get datetimestamp in Excel through VB
  121. VBA Help - on Visible cells
  122. Send Textbox Text to Array
  123. Excel VBA Delete after timer
  124. VBA Pivot Calcfield
  125. [SOLVED] Clear contents with in a range in Excel through VB
  126. Have a shortcut key to command bar
  127. Excel VBA Email with PDF attachments
  128. Compare Two Sheets and Extract Differences
  129. [SOLVED] VBA remove all records from master sheet while auto refreshing and auto archival
  130. Macro auto filter to create report pasting hidden rows. Help
  131. Transfer data from one workbook to another
  132. Using Dynamic Ranges (without range address) inside a Formula
  133. Using a Userform with Multilple Checkboxes to complete a Range of Cells
  134. Copying Sheet into Master Sheet
  135. [SOLVED] Two different additions alternatively
  136. Reading in a Text File
  138. Run Time Error 438
  139. Count unique values with three conditions
  140. Transpose an array - type mismatch error
  141. Sorting a multicolumn listbox
  142. Insert a date in a cell in one and only possible format
  143. vba macro to loop through find and return search criteria
  144. Class module for userform command buttons
  145. Run-Time 1004 Array Copy Error Charts to PPT
  146. Include network file path as a hyperlink in vba email
  147. [SOLVED] Date Format Help
  148. Help with VBA Code: cell values and matching values
  149. VBA website scraping - multiple link clicks to show full table
  150. Compare Main List and Sub List, included new items in sub list to main list
  151. How do I fix this VBA Code?
  152. run macro in workbook1 then go to workbook2 to run macro
  153. Filtering on checkbox text
  154. Want to convert markovitz excel variance model to VBA
  155. Multiple similar If Statements
  156. VBA Script seems working at first glance, but does not..
  157. Unique Random Number Generation
  159. [SOLVED] if and match formula
  160. Help: VBA Training to pull data from online database to worksheets
  161. [SOLVED] Switch Values Between Sheets
  162. [SOLVED] Split the excel based on headings list
  163. Delete multiple files, based on cell value.
  164. Split the excel based on headings
  165. If cells in a column contain a value, input text into another column.
  166. Help with Compile error: Else with out if
  167. [SOLVED] String || How to do selection.replace with space?
  168. User Form to Select Pivot Table Filters
  169. [SOLVED] Shell Command results in Runtime Error 5
  170. Want some idea on transposing function
  171. [SOLVED] Finding Min and Max Times for Each Date
  172. Excel VBA creating emails via web browser
  173. VBA not running correctly in Excel 2016 (worked perfectly 2010)
  174. [SOLVED] Search Replace in Text files - Loop to Next Search & Replacement
  175. Modify the code in the userform
  176. Loop Format (Not Looping)
  177. If cell is N/A, how to replace it with the average value of the cells above and below
  178. Required Conditional formatting
  179. [SOLVED] Adding Email Addresses From Names Rages to Lotus Notes
  180. [SOLVED] Select Folder and Rename Files according to list in excel using VBA
  181. [SOLVED] Analyse a subset of numeric Array only
  182. Excel vba code to iterate through list and match to total
  183. [SOLVED] VBA Code to open PDF file using LastModifiedDate
  184. Need assistance pls
  185. How to group Files in windows explorer with VBA / VBScrip (a .bat file)
  186. [SOLVED] Copied Table Missing First Column
  187. Delete Rows based on Input Box Enrty
  188. Paste Link is greyed out during Paste Special
  189. find all path between any two nodes
  190. [SOLVED] Date Lookup Problem
  191. Count values in rows based on column name
  192. Transpose and insert a column to a row on a different sheet
  193. overloaded excel workbook - ETL replacement ?
  194. Find copy and paste into same worksheet
  195. Excel VBA CDO Email
  196. Insert new row in excel which is protected
  197. [SOLVED] Loop to Cut Down on Long Code
  198. Need to modified Code (getdata) from Closed files for John Walkenback
  199. Duplicate Values only on ListBox
  200. Search string or substring from range
  201. Unique Variable Name for File
  202. Help!
  203. Excel Graph Paper Not Measuring Correctly
  204. Not VBA - INDEX MATCH MAX DATE Question!!! :)
  205. Clearing a Shape from a Chart
  206. Copy data from Pivot table(except headings) to a new tab using VBA
  207. [SOLVED] Conditional Formating Issue
  208. Compare and replace- English and French Translation- Optimization.
  209. Urgent help needed - "Runtime error 9: subscript out of range"
  210. Facing Run-time error-13 "Type Mismatch" while edit and update user
  211. search for words or symbols in files
  212. Search for number in another Excel file and get adjacent cell
  213. modify vba code
  214. Modify Macro to have sheets added in particular order
  215. Auto filling data w/ VBA
  216. VBA reset all pages in multipage
  217. VBA: Workbook won't open until the macro is completely finished
  218. Creating comma separated list from multiple columns
  219. Expanding between two dates (start and end) along with other information
  220. Renaming a closed excel file by info in it, Excel VBA
  221. VBA with a lot of condition statement
  222. Format Object
  223. problem with api call
  224. Help with production counter in VBA
  225. Dependent Combo Box in userform
  226. Download and extract zip file, and open file in it
  227. Not able to use the find command in vba ,Please help
  228. [SOLVED] Automatically enter the value of a formula in adjacent cell
  229. [SOLVED] inputbox coding for invalid selection(s) - column
  230. Combine 2 sheets into 1 PDF file
  231. [SOLVED] Excel Calculation issues with UDF
  232. [SOLVED] Trying to Make Macros Run More Efficiently
  233. Floating point question, exactness of integers
  234. Cancel querytable.refresh
  235. Need to Match two or more rows values based on their ID in another cell
  236. vba help to shorten the my code...
  237. Inserting Multiple Rows in Excel based on cell selection
  238. [SOLVED] expand and complete series excel
  239. [SOLVED] vba conditional formatting - compare range of adjacent cells
  240. Insert and Delete rows based on value
  241. [SOLVED] Conditional Data Validation issue
  242. Highlighting cells that contain specific characters with VBA
  243. [SOLVED] I Need help to reconstruct code to add to existing code, please
  244. Option Enabled Search
  245. Copy Sheet From file to workbook, and save it as origin name in different file
  246. [SOLVED] Need help with highlighting duplicates of data in 3 columns, Please
  247. Macros not enabled etc. Runtime Error 1004
  248. Automatically save on insert/modify cell data.
  249. [SOLVED] Create x,y points from mouse clicks
  250. Creating CAD files using Excel.