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