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 5
  2. Loop Through Multiple Workbooks/Sheets And Extract Values From Columns With Label
  3. [SOLVED:] For and Next code is not being excecuted (if, else if)
  4. [SOLVED:] Trying to program a button to remove an item from a listbox that references cells
  5. [SOLVED:] Newbie. Creating graphs on new sheets help.
  6. Need code string for copying multiple cells from multiple pages across worksheets
  7. [SLEEPER:] Macro referencing Column
  8. [SOLVED:] VBA autofill used range
  9. How to resize the charts in outlook using vba macro
  10. VBA copy paste looping help
  11. [SOLVED:] Delete Columns then add border and highlights
  12. [SOLVED:] Loop in selection
  13. [SOLVED:] Find row containing "True"
  14. CellDragAndDrop disabled in all worksheets
  15. Google Maps Help
  16. Replace Special Characters in Selection
  17. First Excel VBA program getting Run-Time error '48'
  18. [SOLVED:] Runtime error 438 Object doesn't support this property or method
  19. Cell Reference on other sheet. Move All Found up to top in order
  20. Login into website(FB for my case) using MSXML2.XMLHTTP with VBA
  21. Welcome message box
  22. VBA cut,paste and delete
  23. [SOLVED:] VBA Code to Save into a Network Drive
  24. [SLEEPER:] Excel vba error 13 mismatch
  25. [SOLVED:] How to save a user selected file as a variable?
  26. How to create multiple files containing specific details from main file by VBA macro?
  27. muliti cvs files into excel worksheet
  28. [SOLVED:] trying to create vba to copy data when option button is selected
  29. Consolidate Date from Multiple Excel Workbooks using VBA
  30. [SOLVED:] Excel VBA to open PPT file, update links, save as new & break links
  31. Modify conditional formatting in multiple cells
  32. [SOLVED:] Comparison of relative data position row-wise & each cellwise of highlighted column
  33. VBA Named Ranges inc Sheet title
  34. CELL with or without .value
  35. [SOLVED:] Autofilter with date/other format
  36. .Find() Arbitrary Search Direction
  37. [SOLVED:] DLL expects Char*File_Location Having issues figuring out how to correctly pass it.
  38. [SOLVED:] Table Lookup without long nested IFs
  39. How To Destroy An Class Object's Instance From Dll(VB.NET) In VBA
  40. Need help with vba and website API xml data
  41. [SOLVED:] To unmerge cells and fill down blank cells with data from above
  42. VBA Navigation within tables
  43. [SOLVED:] OLEObjects current selection - change color
  44. VBA relative references
  45. [SOLVED:] summing a column with blank cells and replacing the blanks with a value in the sum
  46. [SOLVED:] Sort a table using custom list from another table
  47. scripting.dictionary method
  48. Call API to get info via Excel VBA
  49. VBA Code to link checkboxes to certain columns
  50. How to allow the arrows buttons on a listbox to change the selection?
  51. [SOLVED:] Dynamic Range Help
  52. Trouble Selecting Range.
  53. VBA code to get Internet Explorer language from registry
  54. UserForm Checkboxes
  55. countif and hlookup
  56. [SOLVED:] How to count number of cells (precedents) in a formula for one cell.
  57. [SOLVED:] Rearrange data in a table according to column headers using .Match in Excel VBA
  58. [SOLVED:] Exit sub as InputBox is cancelled
  59. [SOLVED:] How to sync a spin button and combo box, so they always have the same value?
  60. VBA to Concatenate three textboxes on a userform to one textbox on the same userform
  61. [SOLVED:] Pause to pick variable folder when saving a dated spreadsheets
  62. Dynamic Source Pivot
  63. [SOLVED:] Help with loop code please
  64. [SOLVED:] Frequency of a number
  65. [SOLVED:] Add Transpose to line of code
  66. [SOLVED:] Indirect & Networkdays Functions - Tab Reference
  67. [SOLVED:] Applying A Password to Most Sheets
  68. scraping data from a table generated by javascript
  69. [SOLVED:] Extract specific lines from text file
  70. [SLEEPER:] Drop-down list increase viewable items without scrolling
  71. Creating a Pivot table from two or more worksheet
  72. Run-time error '1004' when saving spreadsheet
  73. Speed up a web scrape
  74. [SOLVED:] Filter and Delete Rows
  75. [SOLVED:] Accessing the Add-ins Toolbar
  76. [SOLVED:] Using Loops and Arrays
  77. Database Userform
  78. Coping data from one workbook to another based on specific criteria
  79. User Form Help
  80. Excel Problem Gantt
  81. Compare new sheet vs old and extract data from old sheet into new sheet.
  82. [SOLVED:] Remove duplicates across columns
  83. [SOLVED:] Userforms - Textbox Autofill
  84. [SOLVED:] Need help with looping this code
  85. AdvancedFilter result range EXCLUDING input column title
  86. [SOLVED:] Show UserForm With Application.Visible = False
  87. [SOLVED:] Same condition, multiple columns check, then copy rows
  88. Question about efficiency
  89. [SOLVED:] Do Multiple Replacements in Active Column Cells
  90. [SOLVED:] Export two sheets to xlsm workbook
  91. [SOLVED:] Import free text from multiple word documents to excel columns
  92. Controlling pop-up IE windows
  93. Excel formula to extract string
  94. Iterative comparison in Excel using Macro
  95. [SOLVED:] Need a macro that follows IF statements?
  96. [SOLVED:] Efficient VBA code for conditionally deleting rows in big excel sheet
  97. [SOLVED:] Sort Named Range with VBA
  98. [SOLVED:] Index match, working with values up to .99 but not above 1
  99. [SOLVED:] How to get URLS in excel as images for each row?
  100. Subscript out of range error when trying to OR two arrays together.
  101. [SOLVED:] Loops and lookups
  102. [SOLVED:] View Active Worksheet - Code Module - VBE Code Pane
  103. Delete rows by cell value
  104. [SOLVED:] VB add characters in a cell
  105. Excel VBA - Send Email Error
  106. [SOLVED:] Column Width
  107. [SOLVED:] Store rows in dictionary or collection
  108. Suggestions for rebuilding personal.xls
  109. change the status after press enter button. Worksheet SelectionChange
  110. [SOLVED:] Export to CSV files (faster method)
  111. [SOLVED:] VB, Excel 2007, Issue with autofill & copy
  112. [SOLVED:] import contents of a textbox in a document header into excel
  113. Click on "Run Report" Button in IE 11 Webpage using VBA
  114. Userform problem
  115. Error: Compile Error
  116. [SOLVED:] Save file with todays date - Format Error
  117. [SOLVED:] Pivot table update
  118. [SOLVED:] Concatenate Values with UDF
  119. VBA: color given data with given color.
  120. Checking for blank cells
  121. Open a worksheet with ADODB doesn't work
  122. [SOLVED:] Excel 2007
  123. [SOLVED:] Learning Excel
  124. [SOLVED:] Adding Table in excel
  125. [SOLVED:] Excel Report Page Help.
  126. Help To Compare five Excel workbooks and copying matched data to a new workbook
  127. Chart Height adjustment not working!
  128. [SOLVED:] Excel vba set email on outlook to high importance
  129. [SOLVED:] Loop in .txt file to extract recurring strings
  130. [SOLVED:] VBA, Excel 2007, How to open multiple files in a folder & loop main code
  131. [SOLVED:] activecell.address function
  132. [SOLVED:] Excel 2016 VBA remove duplicates by multiple AND/OR criteria
  133. [SOLVED:] VBA - Filter Data based on criteria
  134. [SOLVED:] Formula Not Copying to Last Row
  135. Searching blank fields in excel and exporting corresponding column values
  136. [SOLVED:] increment a cell reference
  137. [SLEEPER:] Picture Blurry
  138. [SOLVED:] Create Workbooks from Worksheets with Dynamic Auto-Adjusting VBA Ranges
  139. macro to del specific file extension on desktop my documents subfolders with criteria
  140. VBA - Combine sheets in different files into workbook
  141. Search for specific text in multiple sheets and copy next line
  142. get text from txt to excel table
  143. [SOLVED:] Excel Count Macro
  144. [SOLVED:] Need Help Understanding Events
  145. [SOLVED:] Problems using VBA to find and replace within VBA
  146. [SOLVED:] VBA, copy, clear cell, 2007 excel
  147. Search on MULTIPLE column using VBA
  148. [SOLVED:] Summarize Data without using Pivot Table
  149. Add sheet after sheets count
  150. [SOLVED:] More than 10 columns VBA
  151. Downloading from a list.
  152. Application.run gives me back an error message
  153. [SOLVED:] Need help with restructuring Macro Columns to rows, Please!!!
  154. [SLEEPER:] Visual Basic listbox search function
  155. Checkbox to Delete Row
  156. [SLEEPER:] Comparing names in two worksheets for duplicates
  157. Transferring Revised Date from Multiple Word Documents and update in Excel
  158. [SOLVED:] VBA, Excel 2007, How to combine values from other columns into 1 with overwrite exist
  159. Using VBA Macro To Calculate Amount in Cell Excel 2010
  160. [SOLVED:] Need help trying to solve partial matches, please!!!
  161. [SOLVED:] Export data to text files according to fields
  162. Delete 2 cells.
  163. [SOLVED:] Macro for copying the value of one Cell to another cell(s) in specific time interval
  164. Await end of manual calculation
  165. [SOLVED:] Highlight duplicate matches based on citeria need help on this please!!!
  166. Sleeper: Need help on find text then add to another col
  167. [SOLVED:] VBA code for multiple data lookup
  168. [SOLVED:] 4 way Lookup but last lookup is a function query?
  169. simple vba: copy all images with "same length and breadth" to another folder
  170. [SOLVED:] Remove "?" from file property
  171. Transfering data from one main sheet to multiple worksheets based on multiple conditi
  172. Allow one digit or number in textboxes
  173. [SOLVED:] Copy paste Cell inside Table under certain conditions
  174. [SOLVED:] VBA - Comparing the numeric value of two cells for changes
  175. [SOLVED:] Opening access from excel opens as read only
  176. Help with a VBA code to separate a workbook into many different files
  177. Help needed guys please. Object failed
  178. VBA OR VLOOKUP METHOD HELP?
  179. Problem with code importing text from header textbox
  180. VBA to transfer data from one workbook to another
  181. Error Run-time error '424'
  182. Check each cell to see if they match then copy to certain cell
  183. Code for pasting new data
  184. Logic Program for VBA.. may be hard
  185. [SOLVED:] Extract two fields from text files
  186. Excel Small Function Formula (Not using VBA Code)
  187. [SOLVED:] NAME? error with predefined function which previously was working
  188. [SOLVED:] Conditional format macro
  189. Google Search VBA and Pull Data
  190. adding additional calculations
  191. [SOLVED:] How to arrange the order
  192. [SOLVED:] Variable changes its cases.
  193. [SOLVED:] Combine Formula
  194. Updating data in a closed workbook.
  195. Transfer data from adjacent cells to non-adjacent cells
  196. [SOLVED:] VBA find replace object error
  197. [SOLVED:] Embed an image and range to outlook using excel vb
  198. Program takes long to load
  199. [SOLVED:] How to tell a Macro to do nothing for a set period of time?
  200. [SOLVED:] VBA, Excel 2010, Need to change headers in .csv files
  201. [SOLVED:] Count Find Array
  202. Strange character (format) when merging 2 utf-8 files
  203. How to get the numbers from the data
  204. List content of zip files
  205. [SOLVED:] activate opened workbook
  206. [SOLVED:] How to use Array
  207. [SOLVED:] Filter on prior date
  208. INDEX and MATCH query
  209. Select Folder and Break External Links of All Files
  210. Extract string from text file
  211. [SOLVED:] Macro to follow hyperlinks when a certain criteria is met
  212. [SOLVED:] Importing data in consecutive rows
  213. [SOLVED:] Sort each subset of n rows by specific column ranking
  214. [SOLVED:] Check if cell has custom format using UDF
  215. [SOLVED:] Need help restructuring macro to do opposite and adding to macro, please!
  216. [SOLVED:] MSGBOX VBOKONY, Cancel exits sub.
  217. [SOLVED:] Move some cells to next records and delete some rows
  218. Excel help required: How to insert excel remarks in scanned pdf file.
  219. Comparing Dates
  220. Excel Billing Invoice with VBA and mdb
  221. Cell evaluation
  222. [SOLVED:] Use formula to grab data from sheets
  223. [SOLVED:] Break all external links
  224. [SOLVED:] Get last row in range that contains formulas
  225. [SOLVED:] Variable Vlookup vba
  226. [SOLVED:] Copy ThisWorkbook Code with Copy Sheet to New Book
  227. [SOLVED:] Return Row - Column for cell addresses
  228. [SOLVED:] VBA Auto Filter + Paste to New Sheets + Autofill
  229. Need help exporting row data in excel to their own individual powerpoint slide.
  230. [SOLVED:] VBA to Auto Number
  231. [SOLVED:] Put Country Codes in Excel For SharePoint
  232. [SOLVED:] VBA Count IF help
  233. Application.EnableEvents
  234. [SOLVED:] How to call DblClick sub from code VBA Excel
  235. [SOLVED:] Vba far loop too slow
  236. Wildcard with match index
  237. [SOLVED:] Separate Regions
  238. [SOLVED:] VBA formula with variables
  239. [SOLVED:] Help with making code run faster
  240. [SOLVED:] Code for copy and pasting in excel
  241. Copy from one workbook to another without opening the second workbook
  242. [SOLVED:] Count all files with specific extension
  243. Creating Folders from Excel into Outlook (attachment)
  244. Help to create a file from the inputs in the input sheet
  245. Issues with pagination in a worksheet generated by a macro
  246. Copy row based on criteria to existing sheets & constant update
  247. Challenge to get huge Excel Workbook running online
  248. Complex Macros needed to Make and Save Workbooks
  249. [SOLVED:] Deleting empty rows
  250. Custom Option Buttons VBA