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

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