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. Run time error '13' Type mismatch
  2. [SOLVED:] Save sheet - New copy - Modify code witout formulas
  3. Help - Run-time error '9': Subscript out of range
  4. [SOLVED:] Deleting rows on filter
  5. Macro enabled file will not open in Office 365
  6. [SOLVED:] (PDF VBA and Excel) export cover sheet w/ a loop, attach spec sheet from local drive.
  7. [SOLVED:] Vba+Excel - Pivot tables and Dynamic range
  8. [SOLVED:] Macro for copying multiple cells from one worksheet to another
  9. COPY FROM WORD TO EXCEL
  10. VBA Macros Help - NPV
  11. Running a subroutine every half hour up to 5 times
  12. excel workbook pulls data from another excel workbook
  13. Translating Excel formula into VBA code
  14. [SOLVED:] What is yellow dot parameter of a shape VBA
  15. [SOLVED:] Compare one worksheet to multiple worksheets
  16. Dynamic hyperlink to folder Path problems
  17. Outlook to Excel
  18. VBA new row based on last row and input box
  19. [SOLVED:] Blanks in Formula Treated as Zero's
  20. [SLEEPER:] ReadProcessMemory - With a Base Adress + Pointers
  21. Data form displays incorrect date format.
  22. Trouble with Input Box
  23. [SOLVED:] Count number of dates mentioned more than 10 times in a column
  24. Main characters to merge with Sub-characters in record
  25. VBA Work Sheet As Work Book Run Time Error
  26. Help with object shape name and colour
  27. [SOLVED:] vba macro to run multiple macros in multiple workbooks
  28. Gather emails from used range in sheet
  29. Lost Data formatting
  30. [SOLVED:] Application.EnableCancelKey not working
  31. [SOLVED:] Look up in three columns
  32. VBA MS Excel MySQL Connection with ODBC
  33. [SOLVED:] Lock cell after macro got runed
  34. [SOLVED:] VBE Line continuation for Range definition
  35. Grab file size from URL
  36. Error 430 - C# .dll - Reference VBA
  37. Is it possible to automatically create a "Microsoft equation" from an excel formula?
  38. [SOLVED:] Protect/Unprotect
  39. Sum by Colour Vba clarification please
  40. Copy & Pasting in VBA
  41. Find and rename Column Header using VBA
  42. [SLEEPER:] Copy to next cell blank
  43. [SOLVED:] Cant delete contents of a cell ... VBA issue
  44. [SLEEPER:] Range SpecialCells Union LastRow
  45. Print all invoices macro
  46. Copying from 1 Workbook and multisheets to Another Workbook and multisheets
  47. Error VBA in Excel 64-bits
  48. [SLEEPER:] How to run the VB in all Excel Files
  49. [SOLVED:] Save Application Current States. Recall them when needed. (Rescue Workbook)
  50. How do I set/get a range from a certain cell to the last row in that same column
  51. VBA Code to Loop, Find Missing Data and Perform Calculation
  52. [SOLVED:] Hyperlink to Files in Directory - Filter for Specific File Types ONLY to link to
  53. Can files residing on a slow network cause VBA to 'skip'?
  54. Help Keeping a running tally
  55. [SOLVED:] Find and rename Table in Workbook if it is present
  56. Userform field changes not detected when userform invoked from userform
  57. [SOLVED:] Concatenate multiple cells by vba
  58. [SOLVED:] Thousands and Decimal Separator Check
  59. VBA dilemma - Passing Variable from Input box
  60. Excel VBA UserForm TxtBox Calulations
  61. [SOLVED:] Center text vertically inside a combo box or textbox
  62. Macro Subcript Out of Range Error 9 Due to Worksheet Names have a Space
  63. Creating two lists from Multiple Columns
  64. Change cells value base on other cell value by worksheet event
  65. Multiple Spreadsheet data combined into one, and then again output into one workbook
  66. EXCEL VBA SHAPE OBJECT, BUTTON, WORKSHEET HELP
  67. Disconnect Slicers without using slicer name.
  68. [SOLVED:] Dividing a column by a range of numbers
  69. Excel VBA text file parsing help
  70. [SLEEPER:] Filter data to another sheet with VBA calculation
  71. [SOLVED:] Question about Pivot Tables and Filtering Functionality
  72. [SOLVED:] Loop through all rows with data not just first row
  73. VBA Send Email From Excel Spreadsheet
  74. Merge similar rows...
  75. VBA/Macro Help: Copy and Paste x rows above, then find and replace, repeat
  76. [SOLVED:] Count Rows EntireColum one Shot in VBA CountA IsNumber, IsEmpty, Istext, HasFormulas
  77. unable to set the formulaarray property of the range class - IF AND
  78. [SOLVED:] Issue with the Auto Run Macro under Workbook Open
  79. [SOLVED:] Copying data to a specific location, not last available empty row
  80. [SOLVED:] Extract Word into Next Row From DataSet - From Searching WordList In Another Sheet
  81. BeforeDoubleClick trouble
  82. Efficient way to run sub if change via slicer is detected
  83. VBA to download Crystal Reports
  84. Button updates cells with Spin Button
  85. infinite series for the sine using VBA command button and input boxes
  86. VBA coding program
  87. Data Validation List generating with VBA getting 1004 error
  88. [SOLVED:] For loop for different userform
  89. VBA to export images from cells to a folder with a specific name (MSO 2011 or 2016)
  90. VBA: Pulling data from files in the folder & skipping already processed ones
  91. [SOLVED:] Unload all userforms except main userform
  92. Copy And Past On To Next Empty Row
  93. [SOLVED:] VBA compare two columns and list cells that match and the ones that don't
  94. [SOLVED:] Create an Hyperlink if cell value and file name match
  95. How to find if a date exists within 30 days of other dates in a date range in Excel
  96. Conditional Formatting static “Applies To:” field
  97. Conditional Formatting static “Applies To:” field
  98. Sleeper: VBA for copy from one sheet to another
  99. Close excel file if open
  100. [SOLVED:] Filtered List - loop through only counting "visible" rows based on Criteria
  101. [SOLVED:] sorting data by cell value
  102. [SOLVED:] Search Matched File Names in Col A - Import the Text in Col B
  103. Refine code to combine multiple CSV files into single workbook
  104. Help Converting Early Binding to Late Binding VBA Code
  105. [SOLVED:] Transposing each set of 22 items (all from the same column) into rows
  106. [SOLVED:] Multiple Lookup Criteria - Help Required
  107. query close problem
  108. VBA to Retrieve Information from Multiple Workbooks
  109. [SOLVED:] Copying & Pasting Values on Same Sheet to New Table - Pasting Issues...
  110. listobox remove item erorr
  111. Copy down formula then remove formula from where it copied with paste it as value
  112. Help with Count if
  113. [SOLVED:] VBA Coding for Averageifs that needs to dynamically adjust over 8 quarters
  114. Macro to Deduct and Display Time in Userform TextBox
  115. Integrate multiple filesd in a specific directory to one worksheet in a separate file
  116. Loop through all worksheets in chosen folder to remove duplicate rows
  117. [SOLVED:] AVERAGEIF Specific cells ignoring #DIV/0!
  118. [SOLVED:] Scrolling not working for TreeView
  119. Help with merging workbooks
  120. [SOLVED:] Stripping Line Breaks
  121. [SOLVED:] Excel program & left in the lurch--please help
  122. spread repated cells
  123. Code Randomly works - No Pattern to when it does not work. Help Please
  124. Need to VBA Grouping for 2500 Rows.
  125. [SOLVED:] Extracting Form Fields from Word to Excel run-time error
  126. [SOLVED:] Need help const a VBA Macro to record 3rd and 4th digits, place in to rght in col B
  127. [SOLVED:] Need Help: Replace all Cells of a Column with its Caption, if Cells Value is "TRUE"
  128. Multiple Modes
  129. [SOLVED:] Need help restucturing VBA Macro please!
  130. Excel to Outlook Bold Text & Include Auto Signature
  131. vba excel macro data between two dates
  132. [SOLVED:] Import from a Number of Worksheets Listed in a Column
  133. [SOLVED:] Finding Last Column with CF Format - Paste Previous 6 columns format to Empty Column
  134. Help Posting??
  135. Help with compare code
  136. VBA Code will not search subfolders.
  137. ActiveX controls in office 2016 distort when design mode is off
  138. Export excel to pdf with pass
  139. [SOLVED:] Align Row Content with cell format to Left column & Delete Blank row
  140. Breaking Powerpoint slidemaster link from Excel vba + quick macro question
  141. [ Excel ] drop down list with fixed area of dynamic table for user to enter data
  142. advanced filter code - subscript out of range/'Name' of object '_Worksheet' failed
  143. Sleeper: Scan barcode to two documents at the same time
  144. Return All Matching Rows On Button Press
  145. [SOLVED:] [VBA] Copying cells from one sheet to another
  146. VBA code to build Pivot tables in “Existing sheets”.
  147. How to save PP as pptx instead of ppt from Excel VBA
  148. Excel VBA Queries
  149. VBA Loop Through Columns
  150. Userform to Image
  151. [SOLVED:] Dynamic Table Array for Pivot Table in VBA
  152. Help with vba
  153. [SOLVED:] VBA CellMovement from ActiveCell
  154. [SOLVED:] How to check if Cells has content or not
  155. How to access Onedrive folder using macro / VBA?
  156. VBA to Delete Leading ,Trailing and Excess Spaces in Excel
  157. VBA Deleting rows from specific cells based on some condition
  158. [SOLVED:] Multiple lookups for string in once cell and return comma separated values
  159. [SOLVED:] Table editing
  160. Average Function-Cannot do Copy and Drag with Quarterly Avg. Calc - Periodicity Issue
  161. [SOLVED:] VBA Clear contents help
  162. How to express my cell range dynamically (using numbers) in VBA?
  163. [SOLVED:] Import Text Content From File - Stored in SubFolders - If It Matches File Name Col A
  164. [SOLVED:] Create a Copy of workbook with selected sheets
  165. [SOLVED:] Transpose rows to columns
  166. [SOLVED:] Sending email with links disabled in sheets
  167. Advice needed
  168. Transfer Selected Body Content from Outlook to Excel
  169. [SOLVED:] Set powerpoint presentation opened from excel as active
  170. [SOLVED:] Error with Find (438)
  171. [SOLVED:] Linking macro in one sheet to anothwer sheet
  172. help building formula string
  173. Help Creating a Custom Desktop Shortcut
  174. [SOLVED:] Folders path in excel cell
  175. VBA Copy/Paste Data Based Off ActiveX Dropdown Box
  176. Excel 2010 formula reccomendations
  177. Macro to identify selected point in Excel chart
  178. How to match index with two criterias and multiple dates?
  179. VBA Copy An Paste Only Copying 1st Row
  180. Identify Font used in XLS sheet
  181. VBA Code/Macro Help
  182. [SOLVED:] Merging workbooks
  183. Add Usedrange property in the existing code
  184. [SOLVED:] VBA or Formula? to assign a number based on driving miles
  185. Make the range dynamic
  186. Filter and create outlook email
  187. Automation of email classification selection
  188. How to remove duplicates within duplication sets based on criteria?
  189. [SOLVED:] Copy color from range of cells
  190. How to close excel properly
  191. VBA Code Indentation tool for x86 and x64 Excel
  192. [SOLVED:] Formula/VBA help
  193. Two Combo Boxes Active Control in the same sheet affecting each other
  194. Extracting Word Table cell Information from Multiple .docx Files on an Intranet page
  195. Match cells from another workbook & then copy
  196. [SOLVED:] Getting Attachments from Outlook with Excel VBA
  197. [SOLVED:] Sequence Function
  198. Macro to save spreedsheet as new file
  199. [SOLVED:] Two-column data transferred to single cell
  200. VBA to look for certain parameters in a word and populate a single data to excel
  201. [SOLVED:] Need Macro To Change And Add So Many Days To A Cell With A Date
  202. [SLEEPER:] Help with LinkedIn
  203. Import/Extract Information from Word to Excel using VBA
  204. Userform: How do I disallow "save & exit" if requried fields are not filled-in?
  205. [SOLVED:] Macro works only in one workbook
  206. [SOLVED:] Pivot field moments Postion{1,5}. in case if the items availabe
  207. Outlook to Excel Table using VBA having a small issue
  208. Copying of one Cell Value each Row as excel runs down the Page.
  209. [SOLVED:] Filter and name the rows when available
  210. [SOLVED:] Auto E-Mail an Excel File When Saved???
  211. Help wanted....
  212. Calendar Control Not Working using VBA Code
  213. How to amend a formula to a new criteria
  214. when run macro, original file auto open
  215. [SOLVED:] Add missing text in certain cells
  216. [SOLVED:] How to prevent a Pivot Table from Re-Sizing
  217. Do until loop in Excel
  218. Transpose column by date( Excel or VBA)
  219. Transpose Column to Row (2 column)
  220. VBA code for if else based on date
  221. [SOLVED:] Catching error messages
  222. From Template file Force Save and Close
  223. Create PDF of Workbook or Individual sheets by last used row & column and send email
  224. Gmail search box automation - Need Help
  225. [SLEEPER:] Group Columns are not expanded
  226. [SLEEPER:] Paytm Automation help
  227. Copy specific links into excel from explorer html
  228. [SOLVED:] Fill an array LIKE a multiplication table with a macro
  229. Assign value to shape by double clicking
  230. Autosum current column in a table
  231. [SOLVED:] VBA To Hide or Show Rows
  232. Date Automation
  233. how to export the data into .excel in VBA
  234. [SOLVED:] Assigning datalabels to doughnut charts with vba
  235. [SOLVED:] Protected View, Enable Edit causes Runtime Error 91 or 1004
  236. Help with using a UDF as the criteria for a countif formula
  237. [SOLVED:] Convert Text body in email to HTML
  238. [SLEEPER:] VBA Exam type of questions
  239. [SOLVED:] If only blanks PIVOT should not be inserted
  240. Need one Sub for all CheckBoxes.
  241. [SOLVED:] Pass Sheet Codename as argument to Subroutine
  242. Need help constructing a vba to remove duplicates and its original and spare the uniq
  243. [SOLVED:] How to Save listbox items to .csv file
  244. How To Create a spreadsheet in excel
  245. Problem about data form excel to API
  246. Embedded image in Gmail only works with .Display before .Send
  247. Is a Multi-Cell Row Power Search Possible?
  248. [SOLVED:] Issue with AVERAGEIF
  249. [SOLVED:] How can I run VBA Worksheet_BeforeDoubleClick on a (new) daily extract.csv
  250. Save Specific Protected Sheets to a new Workbook