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:] Function to Pass Workbook and Worksheet objects giving Type Mismatch Error 13
  2. Need Help Highliting Some String in Cell and Columns With Macro!
  3. Copy & Append Paste from various workbooks into one master
  4. Password to save worksheet as new workbook
  5. Excel 2016 VBA on MAC to Open A File
  6. [SOLVED:] Code only copies certain column.
  7. [SOLVED:] Add extra worksheet
  8. [SOLVED:] VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range'
  9. Copy Rows with Certain Values
  10. fastest way to copy multiple range to multiple sheets
  11. [SOLVED:] Loop thru validation list - filter multi sheets - generate individual files
  12. [SOLVED:] Count based on two criteria from different columns
  13. [SOLVED:] File Format and Extension Don’t Match
  14. help with vba code
  15. [SOLVED:] Splitting large range of data into multiple cost center outputs in txt-format
  16. date Macro
  17. [SOLVED:] VBA to Limit what Columns a User can View--Question about Security
  18. VBA-Import text file of yesterday's date which is the file name
  19. Why will macro will move pdfs and xlsxs but not msgs?
  20. Need Help Creating a Macro
  21. lookup between different worksheet.
  22. [SOLVED:] Extract dates from a cell containing a string of data
  23. [SOLVED:] Fill in a row until bottom of the table
  24. Help needed for layout display after calculation.
  25. [SOLVED:] Cell is equal to another cell until you write something in it
  26. [SOLVED:] SharePoint and SaveCopyAs method
  27. Read all Excel files in a folder and edit them via UI
  28. [SOLVED:] Hide rows with option buttons
  29. regexp to find multiple instances of the same structure term?
  30. Nested classes with dynamic array
  31. Export to CSV with New Name and Time Stamp
  32. [SOLVED:] How to know form Option button name or number
  33. [SOLVED:] Macro help - matching times to periods
  34. Transpose using VBA
  35. Swap last and first word in a sentence in an excel column
  36. [SOLVED:] Merge Workbooks into one - Help in Folder Picker
  37. A function that crashes: Compile Error: Procedure too large
  38. VBA to open excel-sheets, updating link, saving and closing
  39. [SOLVED:] Hide rows when check box selected
  40. Hi. Need to copy/cut rows from sheet to another at top of dataset
  41. Problem with Charts
  42. UP/DOWN/INSERT/DELETE macros part of line
  43. [SOLVED:] Move Duplicates to Result Sheet
  44. Extracting data from json api
  45. [SOLVED:] Hyperlink formulas in VBA code - one is working and one is not
  46. VBA - conditional copying different column ranges
  47. How to move data from one variable to another
  48. Can you lock one filter in a pivot table?
  49. Help with VBA Macro
  50. [SOLVED:] Help : Compare texts in two columns in the same row and get the similarity percentage
  51. [SOLVED:] create sheets based on extensions files and copy to each months
  52. Update a new sheet from Userform
  53. VBA - seet 1 cell value (H2) to copy paste in activecell column c sheet 2
  54. Import Second Excel file
  55. [SOLVED:] help for VBA conditional formating count on correct color
  56. Search for a file in folder and subfolders (mac version)
  57. [SOLVED:] search files across multiple sheets and open & highlight
  58. [SOLVED:] UCase Help
  59. delete blank cells in every row individually
  60. Axis Ticklables to ObjectThemeColor
  61. [SOLVED:] error 1004 - VBA Delete column
  62. Not Working : VBA : Create folder and access files from One Drive
  63. With PivotTable: Count consecutive days that meet a criteria
  64. [SOLVED:] Difficulty Changing Data with a Hyphen "-"
  65. vba for mac book pro
  66. Loop through column, range.copy to another sheet based on cell value
  67. [SOLVED:] Pivot Tables: error in 'Field.CurrentPage = NewCat'
  68. How to Handle Blank cell value in VBA
  69. [SOLVED:] editing VBA code
  70. How to read in server name, software name and version from a text file
  71. Help : Date Picker in VBA user form and view data from data entry wb
  72. Find the duplicate from one work book and remove the duplicates in another workbook
  73. Rows to hide and unhide based on two columns
  74. Find Specific Word from the cell by referring a list (VBA)
  75. [SOLVED:] Not Working : Worksheet_Change Event
  76. Excel VBA shift selected cells in various columns up/down for a specified number cell
  77. Import, Filter and Sort Multiple Columns
  78. Collecting Data From Multiple Users
  79. VBA and Excel Formula
  80. [SOLVED:] Trying to make specific cell contents bold
  81. [SOLVED:] Search column for specific value, then delete rows found, leaving the first instance
  82. [SOLVED:] Request help to find missing dates in a date range for the user
  83. [SOLVED:] Highlight Matching Text in different cells
  84. Office 365: Application.CommandBars("Workbook Tabs").ShowPopup issues
  85. [SOLVED:] VBA Text Comparisons Identifying Differences
  86. [SOLVED:] How to do sequencing number after rows duplicated
  87. [SOLVED:] Not Working : Opening an Excel workbook from SharePoint in edit mode from a user form
  88. Autofilter help needed - encountering Autofilter method of range class failed error
  89. [SOLVED:] Trying to allow a TextBox entry on UserForm store in variable
  90. Print sales transaction receipt error
  91. VBA Help with Multiple If conditions
  92. Excel 2019: Range.Find(Number) Trouble
  93. [SOLVED:] Superscript in a Function
  94. [SOLVED:] Formula to collect charges
  95. [SOLVED:] Comma separated list from columns
  96. VBA help to stop one code from affecting another
  97. [SOLVED:] Searching for multiple texts within a cell (InStr)
  98. product csv from sheets
  99. VBA Command
  100. [SOLVED:] Change format of ConvertDegrees function
  101. [SOLVED:] Not Working : Sum of Hours
  102. Create a loop in VBA to copy data out of different files
  103. [SOLVED:] Slow Calculation of Sum Row
  104. [SOLVED:] Calculate the SUM from One Place to Another
  105. [SOLVED:] convert cells in worksheet to values
  106. [SOLVED:] Vba Array Shuffle Giving an Error and Lost Datas!
  107. VBA Code/Macro for Extracting data from Sheet 1 to Sheet 2
  108. Help required to extract data from rows to column in Excel2013
  109. [SOLVED:] Not Working : Load data from excel in user form and update / delete
  110. Compare with two column and return value or highlight match word(s)
  111. Combination data types
  112. [SOLVED:] Format date within formula in VBA
  113. How to apply VBA formula to stop row height from readjusting ? (Excel File)
  114. VBA Application.Run for Running Macros-with-Parameters Stored Inside an Excel Cell
  115. Keeps overwriting my output
  116. [SOLVED:] Userform with calendar month code to bold 2 inputbox result day label value
  117. [SOLVED:] pushbutton and countif/deletes
  118. [SOLVED:] Simple read file macro in Excel VBA on Mac OS X
  119. [SOLVED:] Syntax error - can't see why!
  120. [SOLVED:] ClearContents of merged cells?
  121. Concatenate in VBA?
  122. CREATE WORKBOOKS FROM TEMPLATE WORKSHEET AND TABLE OF DATA
  123. Help : take out numbers from a string after a specific word till next space or comma
  124. Office 365 - Using ComboBox / Text Box & Lists from Dynamic Tables
  125. Excel VBA - causing issues
  126. [SOLVED:] Cannot get two subs to run together
  127. Remove duplicated rows with VBA
  128. [SOLVED:] Need Help Creating a Macro
  129. Office 365 - Select Dynamic Sheet Names in Array
  130. [SOLVED:] Office 365 - Remove All Tables, ListBox & Macros from a Dynamic Range of Worksheets
  131. Sensitivity Analysis
  132. Statistical confidence plot in Excel
  133. [SOLVED:] Protect Workbook (Lock Certain Cells) and still have VBA run on unlocked cells??
  134. [SLEEPER:] VB Editor Menu Keyboard Shortcut Assignments Change with Macro / Code …
  135. VBA Formula for Splitting Property Address to Multiple Columns
  136. [SOLVED:] Select Sheets Starting with "XXXX" and Remove Macro from Sheet
  137. Copy some data from one Sheet to another and create a list
  138. Click IE Popup window
  139. [SOLVED:] VBA “folder” sorter
  140. how can i create userform using simpson rule for a function in excel vba
  141. How to get the number of instances of a class
  142. [SOLVED:] Exel crash when VBA frames manipulation
  143. Import XML to worksheet with mapped schema
  144. [SOLVED:] Change sheet tab color automatically based on cell values
  145. Sumif with integer and from another sheet
  146. Copying and pasting values into a table below the previous entry for many days
  147. [SOLVED:] copy data with pushbutton
  148. Find Form Controls with Value not set
  149. Auto Update Excel Data
  150. Help VBA CODE to include negatives in the loop calculation
  151. [SOLVED:] Count Dates in a List of dates for every employee for every month
  152. Selection Change where a merged cell is involved
  153. Close and save changes in one workbook from another.
  154. delete folders on search
  155. [SOLVED:] VBA to Delete Duplicate Info on Same Date
  156. Worksheet_Change multiple ranges and different formulas
  157. VBA to merge multiple workbooks with demarcation
  158. VBA Macro Causing Excel to Freeze When 2nd Copy of Sheet Added to Workbook
  159. show and hide photos with formula
  160. Matching the data.
  161. Copying sheets and updating values from a main sheet
  162. [SOLVED:] Cannot control the popup window
  163. Macro to Look for Specific text in other workbook and report value in cell beneath it
  164. Conditionally Filter chart categories according to the x-axis labels
  165. [SOLVED:] Close All Instances Of Excel Without Saving Any Changes
  166. [SOLVED:] Need help fixing/understanding Macro
  167. Vba : copy Transpose in 2 differents rows
  168. Efficient Way of Copying Data from an Input Sheet to a Database
  169. Shift pattern conversion
  170. [SOLVED:] Shared Workbooks with Hidden Tabs
  171. listview background color
  172. [SOLVED:] Counting the occurrence of each entry in a column
  173. [SOLVED:] Excel cannot access 'ExcelVB'
  174. Script not Running
  175. Need Help Finding Specific Cells and Determining if there are values in it or not
  176. Merge Workbooks based on Number of Row of Data
  177. Vba if iserror issue with vlookup
  178. EXCEL VBA - Dependent FORM Drop Downs & Excel Tables
  179. [SOLVED:] Date Increasing
  180. [SOLVED:] To Copy and Split the Name to First and Surname from Another Workbook
  181. Excel Formula : =MIN(IF)
  182. VBA Bold Text
  183. what's going wrong with the code
  184. What's wrong with this code?
  185. Automate a Pivot Using VBA
  186. vba help - Count only Alphabets from a string using Regular expression
  187. How to close it
  188. RE: SAP scripts VBS loop - Help required
  189. To automatically create a variable number of worksheets, name them and the enter the
  190. VBA: ActiveSheet started spitting out 1004 out of nowhere
  191. VBA Excel - Conditional Formatting in Table based on group
  192. Concatenate with ";" if values of 3 columns are same
  193. Conditional If in VBA
  194. [SOLVED:] Export to single PDF from matrix of range and sheets
  195. [SOLVED:] Help : Highlight the row basis of a cell selection and restore on selectin change
  196. [SOLVED:] Range("R1C1") gives error
  197. Extract data from automatic pivot table
  198. [SOLVED:] VBA Code for IndexMatch Function not working without error
  199. [SOLVED:] ORDER OF PDF MERGING - PLEASE HELP
  200. Sleeper: How to dynamically add data into a new column to the right
  201. VBA how do you change the thickess of a line using AddLine
  202. [SOLVED:] VBA Loop Control Variable Issue / Question
  203. [SOLVED:] Add between 10% to 20% random to numbers in cloumn F
  204. [SOLVED:] Date -Time not populating correctly
  205. [SOLVED:] Help Required : Random Sampling of Data
  206. Paste Excel Range into Powerpoint
  207. Display succeeding column data while skipping blank cells
  208. [SOLVED:] Multiple errors in VBA trying to get HTML elements by Class & Tag
  209. VBA Code to Disable Insert Header & Footer on Ribbon
  210. Removing Specific Fill Colors
  211. HinstancePtr vs Hwnd?
  212. [SOLVED:] Take subheading and move to front of each row
  213. How to Declare Object Variable with Direct Memory Access?
  214. Help to filter list
  215. [SOLVED:] VBA To Insert A new Row with Specific formatting
  216. [SOLVED:] Macro removes editing options selected when re-protecting worksheet after macro runs
  217. Using SumIF with Cell.Interior.ColorIndex on another WorkSheet
  218. assistance from experts to fixing theses codes
  219. [SOLVED:] Save Worksheet Tabs as Seperate PDF Files to Folder
  220. One PDF with Print Page Order - A variation
  221. [SOLVED:] VBA to Print the Comments of a single cell
  222. variable = worksheet (=>expected identifier)
  223. VBA to loop through sheets in workbooks in a file directory and add missing columns
  224. VBA Clipboard Statement
  225. Using Excel to send e-mails through IBM Notes
  226. Printing multiple workbooks into pdf
  227. VBA Add slide to the end of the presentation
  228. Print a sequence of sheets
  229. ODBC Refresh Connection String Error in VBA / Run Time Error 1004
  230. Exporting from Word Textboxes to Excel
  231. Tracking equipment run times with multiple starts/stops
  232. Remember selected cells in other worksheet
  233. [SOLVED:] VBA to use Selection.Address in a formula
  234. HIDE COLUMN BASE ON CELL VALUE OF ZERO AND 1
  235. extract OLE image from access to file by running sql adobd from vba excel
  236. for loop in vba
  237. VBA to Hide and Show rows based on multiple ranges provided
  238. checking for duplicates when creating macro to move data into master sheet
  239. Can't output values to cell
  240. Move csv file to new folder
  241. Drop down multi select while also changing what is shown in the cell
  242. VBA to Extract digit and text from two different columns of excel
  243. How to get mainserver ping response on userform
  244. InsertVBComponent not working
  245. [SOLVED:] VBA - Formatting Height of two Merged rows
  246. [SOLVED:] Cumuative Sum
  247. Help with loop and MID function
  248. VBA for multiple files with date - maximum values
  249. Casting Couch
  250. [SOLVED:] Offset Rows