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