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

  1. Formulas no longer work in Excel for Office 365
  2. [SOLVED] vba sum format number with currency
  3. UserForm to Return the MAX date in a TextBox resulting from VLOOKUP in ComboBox
  4. [SOLVED] Add Roundup formula to VBA button
  5. [SOLVED] help adjusting code delete empty rows based on condition from sheet1 to sheet2
  6. VBA code to copy to new workbook and insert pivot
  7. [SOLVED] Highlight cells that contain specific words
  8. [SOLVED] question re "for each range in target"
  9. Please help VBA Coding for Repeat Task for Step 2 to Step 6
  10. Advice on comparing excel workbooks
  11. Help!! Merging multiple Excel workbooks into one master sheet.
  12. VBA to check if object is inside or outside of freeform area
  13. [SOLVED] I want my reset button on VBA userform to do nothing if "no" is selected
  14. [SOLVED] How to define range based on the value of another cell
  15. Check if labels are visible
  16. [SOLVED] copy multiple rows of numbers to new location on same sheet.
  18. [SOLVED] Part of a string
  19. [SOLVED] Delete text line with specific word from multiline cell
  20. Search for a string in text files.
  21. Publish to Sharepoint
  22. [SOLVED] Transferring selected cells to a new sheet
  23. VBA mult AdvancedFilter - Unique Column 1, Greater than 0 Column 3
  24. Replacing Date with Period Based on Matrix
  25. auto fit cell height for merged cells in sheet that has protected (locked) cells
  26. Convert Binary to decimal on and vice versa on VBA
  27. Solver in Userform Linked in Excel
  28. Using non-contiguous ranges in Solver VBA
  29. Help VBA search
  30. [SOLVED] Finding cells formatted with colour gradients of various colours
  31. Like expression with AND or OR
  32. Formula/vba - Summary Report without Pivot
  33. [SOLVED] VBA - Filling Master Template
  34. Room Booking System
  35. combine multiple txt files
  36. [SOLVED] How to Add Different Texts to End of Excel Cells Macro
  37. VBA - Collection help..
  38. Date Picker VBA that will work on all versions of excel
  39. Copying multiple text files into one excel but different tabs
  41. [SOLVED] Pull rows from array given two conditions
  42. [SOLVED] Run-time error '424': Object Required
  43. simple copy-past
  44. Subscript out of range error in VBA code
  45. Replacing multiple numerical values
  46. Insert a line break after word wrap
  47. newbie vba questions & help with posible loop for multiple cell values to sheet
  48. [SOLVED] VBA- Variable declaration help
  49. VBA Array Help in filtering data with logic
  50. [SOLVED] Combo Box Index select
  51. [SOLVED] Combine common worksheet names when splitting a file
  52. [SOLVED] Turning off alerts issue
  53. How to Copy Paste Symbols-Phonetics Data to Excel sheet?
  54. Range.Find Issues
  55. [SOLVED] When you have one workbook, two windows, does any event happen closing second window?
  56. Is there any event allowing Cancel of closing a Window (not closing a Workbook)?
  57. Apply AutoFilter based on selected cell in another sheet
  58. Declared public variables have ceased to pick up values
  59. [SOLVED] Copy and rename multiple sheets
  60. Excel 2016 Open Read Only file
  61. [SOLVED] Interactive Way to Search Based on First Few Characters Typed
  62. [SOLVED] Between two numbers
  63. [SOLVED] Clear all textboxes except 1
  64. [SOLVED] Copy value - Another Excel
  65. Splitting up a String
  66. Delete certain rows and highlight certain cells
  67. How to remove [TAG 001], [TAG 002], [TAG 003], etc from string
  68. Prepare hierarchical and non-numeric pivot tables in Excel
  69. Search string if it contains words from a range then replace with adjacent cell
  70. Inserting Recordeset into Access DB via VBE - Error operation must be an updatable...
  71. [SOLVED] Sum values vba code
  72. Running macro on files in a folder: impossibly hard!
  73. Count only visible data after filtering
  74. VBA to perform lookup for individual lookup range
  75. [SOLVED] Cannot show merged cells
  76. copy and change date
  77. [SOLVED] Copy Data from worksheet to another one with VBA
  78. Bad file name or number - Runtime Error 52
  79. [SOLVED] Changing Column Headers
  80. VBA code: copy data from sheet and paste values onto another specidied workbook
  81. Get first and last dates (dd/mm/jj) from year range
  82. vba - Extract Unique values from Single Column via Colllection and Dictionary
  83. [SOLVED] Data Conversion using Dynamic Multi-Dimensional Array
  84. [SOLVED] Linking a commandbar button to a macro in an addin
  85. Macro for sorting by lot number, splitting table w/new header, then sort by due date
  86. [SOLVED] Fill Column
  87. Array only returning first column of values
  88. [SOLVED] Pass Params on Activate event
  89. easy VBA seek for help!
  90. Help with random selection and variable criteria
  91. Multiple Rowsource in combo box?
  92. pick a new interior color from an array when next color is needed
  93. [SOLVED] How to fetch data from a excel table with multiple rows.
  94. [SOLVED] Match FileNames and then Merge those PDFs
  95. Userform with listbox and checkboxes that finds values on a worksheet
  96. counting number of occurrence of a value and depositing that number in another column
  97. [SOLVED] Refer to range in cell formula
  99. Select Random cells from range
  100. Get name of procedure
  101. Reconciliation based on recurring values
  102. [SOLVED] [R1C1] Formula with a loop index in VBA
  103. [SOLVED] VBA code to set print preferences
  104. [SOLVED] How to Selection.Insert Shift:=xlDown with keep destination formatting?
  106. [SOLVED] Problem with hiding rows
  107. Multiple dropdown list
  108. Excel Sumproduct Count Blank Cell as well...
  109. Caption label
  110. Modify macro to output to Combobox
  111. Extract Items from String and then Sort
  112. Matching data from columns with offset multiple row data in other worksheet
  113. Cell content as part of filename
  114. Count colored cells in a range using columns and rows, output result
  115. VBA scrip to sort data inside sheet
  116. Number help
  117. [SOLVED] Copy / Paste data ranges to specific locations
  118. application.run - return value byRef
  119. Control Tip Text
  120. [SOLVED] How to get the first & last range value for this type of data...?
  121. Updating a Chart while VBA is running
  122. Copy Multiple Files from Absolute Paths to SharePoint with Same File Names
  123. VBA problem
  124. [SOLVED] Copy and paste VBA
  125. [SOLVED] VBA code for selecting data from statement to output sheet
  126. [SOLVED] VBA Code to remove Data embedded in the "Pick From Drop Down List"
  127. [SOLVED] Userform open from one worksheet and referencing another worksheet
  128. VBA code not working in 365
  129. Error Handling for InputBoxes
  130. Run-time error 438: Object doesn't support this property or method
  131. [SOLVED] Copy .pdf files from one location to a new folder based on a list of cell
  132. [SOLVED] VBA Code to add groupings to subtotals
  133. [SOLVED] Need help with logic
  134. VBA Advanced filter help..... Criteria excluding a list
  135. [SOLVED] BeforeSave and Userform: Issues with saving the excel file
  136. [SOLVED] Multiple selections from drop down list
  137. On editing protected view programmatically , display setting are getting changed .
  138. VBA filter and cell formatting
  139. Copy data from one sheet to another sheet where the values are matching
  140. [SOLVED] Help import from csv file
  141. Search data using Userform and then scroll through matching records
  142. VBA how to superscript characters in a string following an apostrophe?
  143. [SOLVED] Declaring Variable Type - Excel 2013
  144. Export as CSV file
  145. User Form - Many Text Boxes - Restrict One Text Box with Password for Editing
  146. Loop through a folder and copy data from files to another WB
  147. Word file - filled using excel and send by email as attachment
  148. Why is my code showing error??
  149. [SOLVED] VBA to replace previous table and check if one cells value is equal to the previous o
  150. Print to PDF file
  151. [SOLVED] VBA Code to Run Code Across Multiple Worksheets at One Time
  152. Array issues - one vs two dimensional
  153. Excel VBA code to Delete 'Heading 1' from Word Document
  154. Excel to JSON -- bracketing
  155. Findvalue from 2 searchstrings
  156. VLOOKUP not working properly
  157. [SOLVED] Use .Range("A1:A10000") to end of records?
  158. How can I control when and if my chart updates and not updates?
  159. My chart "hides" from view sometimes after running or when idle.
  160. Two userforms in one sheet
  161. [SOLVED] Create a File list with metadata
  162. Filepath to reference cell value
  163. [SOLVED] VLOOKUP Not Updating when Data Repeated
  164. Userform - Compile Error: Invalid qualifier
  165. [SOLVED] Format transfer to sheet 2 after match in sheet1
  166. Creation of File list in a new Workbook
  167. [SOLVED] Printout VBA
  168. [SOLVED] VBA Code to stop loop if cell / range is blank
  169. Crank Nicholson
  170. Crank Nicholson Method
  171. [SOLVED] 2 separate change events code issue (Floating Cmd Button & List box selection)
  172. Input user form to change cell value
  173. Excel help copy and paste from sheets then move to next row
  174. Formulas NameManager
  175. Excel vba merge cells based on duplicate cell data
  176. Transform data type in column
  177. VBA to Recalculate Grand Total
  178. Application.Match gives 'Type Mismatch' only on descending date values, match type=-1
  179. VBA Code to edit and update existing data
  180. Rename New Sheet?
  181. Macro to clear hidden contents based off other cell values
  182. Update Shared Spreadsheets
  183. Active X Textbox Content to Userform Textbox
  184. [SOLVED] Button click to change shape color
  185. adjusted code show the data in listbox on userform
  186. VBA pivot table error 5
  187. Making 2 Dependent drop downs
  188. Skip blank from Auto Filter
  189. Runtime Error 438
  190. Excel Macro help - If target cell in range of cells.
  191. Code that detects data in cells and pastes data into the next cells
  192. User defined directory not working
  193. Flags on birthday calendar
  194. [SOLVED] Produce parts list from breakdown
  195. VBA: Filtering for a date range from 2 ComboBoxes for dates
  196. [SOLVED] Hyperlinks with changing Sheet Names
  197. Set Range Using a Function
  198. Importing pictures by directory string
  199. Debug stops running macro and will only continue in step mode
  200. autofit cell height for merged cells
  201. Search with Table
  202. Yearly Calendar Project
  203. Application.FileDialog clean up
  204. VBA Code to Loop and Calculate Subtotals with blank rows
  205. Help needed for Text String whenever get typed anywhere in worksheet gets BOLD
  206. Backtesting futures using VBA
  207. conditional formatting help
  208. Filling ComboBox?
  209. [SOLVED] VBA newcomer - help with IF to determine whether to run code
  210. Procedure too large error
  211. Data migration between tabs using VBA
  212. Search and Fill Listbox
  213. vba excel function return #VALUE!
  214. Copy Data from one Worksheet to Another
  215. Convert from range to tables and code support?
  216. [SOLVED] Find and replace module help
  217. VBA Error When Add / Delete a Row
  218. How to Calculate Standard Dev without using the worksheet function in VBA
  219. [SOLVED] Abbreviate the next succeeding instances of scientific names
  220. type mismatch error that i didn't get before
  221. subtract today's date from a date in another column
  222. Find cell matching text then get last row before blank
  223. Case issue
  224. [SOLVED] VBA macro code to expand a certain column
  225. [SOLVED] Transfer data from Excel to double column of information in Word
  226. [SOLVED] Vba Custom Format "0000" in File Name
  227. [SOLVED] Excel VBA to read txt file, input all data into one cell
  228. VBA Update from Excel to SQL Table Contents.
  229. [SOLVED] Good way to mark a textbox so users know it is required to fill
  230. How to calculate Volume Weighted Average Price (VWAP) of all relevant deals
  231. cumulative sum between two dates
  232. Fetching data in various cells based on on one cell
  233. [SOLVED] select data using drop down list
  234. [SOLVED] CTRL + Shift + Down in a Macro
  235. tracking worksheet changes over multiple columns
  236. [SOLVED] VBA copy / paste to the next specific row
  237. [SOLVED] Replacing drop downs by two multichoice listboxes to copy&paste in between sheets
  238. [SOLVED] Data uploading from userform to excel when "No" is selected in msgbox
  239. Store in DataBase
  240. [SOLVED] struggling with vbYes and vbNo coding
  241. [SOLVED] Get data in various cells based on a cell value from another sheet
  242. [SOLVED] VBA to insert blank rows based on conditions
  243. [SOLVED] Remove Header / Footer from files in folder
  244. Excel Vlookup and multiple search results
  245. [SOLVED] setting a cell to a formula
  246. [SOLVED] VBA to calculate TOTAL based on condition
  247. importing sheet from another file - issue with data validation
  248. [SOLVED] Parenting Calendar in excel exported to CSV for import into google calendar
  249. Change first letter of word to uppercase
  250. [SOLVED] Removing duplicate from keywords