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

  1. Vba far loop too slow
  2. Wildcard with match index
  3. [SOLVED] Separate Regions
  4. [SOLVED] VBA formula with variables
  5. [SOLVED] Help with making code run faster
  6. [SOLVED] Code for copy and pasting in excel
  7. Copy from one workbook to another without opening the second workbook
  8. [SOLVED] Count all files with specific extension
  9. Creating Folders from Excel into Outlook (attachment)
  10. Help to create a file from the inputs in the input sheet
  11. Issues with pagination in a worksheet generated by a macro
  12. Copy row based on criteria to existing sheets & constant update
  13. Challenge to get huge Excel Workbook running online
  14. Complex Macros needed to Make and Save Workbooks
  15. [SOLVED] Deleting empty rows
  16. Custom Option Buttons VBA
  17. Custom XLAM ribbon question
  18. Accessing Hidden Sheets Via Hyperlink
  19. Every time i run the macro it has different values, need help please
  20. Last saved issue
  21. [SOLVED] How to write VBA code to auto insert the last row occupied into Master Sheet
  22. [SOLVED] Write an IF statement relating to 2 different worksheets
  23. Copy function from workbook to another in VBA
  24. [SOLVED] Ctrl-C selection in memory - how work with it by VBA Excel code?
  25. Date Variable Showing 12:00:00 AM, Why?
  26. [SOLVED] Combining Static Series and Dynamic Series in a Dynamic Chart Issues
  27. [SOLVED] Unwanted selection change
  28. Can you customise the results from comparing two worksheets?
  29. If-statement with relative values
  30. Adding a certain number of cells between sets of data based on a comparison
  31. Help with copy paste code
  32. Convert from Text to Columns Doesn't Work if Source is Modified
  33. Values are not copying over as entered on one sheet to another.
  34. Identifying file type in excel
  35. [SOLVED] Excel coordinate projection - distance and bearing
  36. VBA to copy url from excel sheet and open in webpage and copy source to notepad
  37. [SOLVED] Search for data highlighted in red return it and return the data in next two columns
  38. [SOLVED] PivotTable.DrillDown and filtering the output
  39. insert six rows at specific points
  40. [SOLVED] Autofilter latest event date
  41. [SOLVED] Store special cells in one range
  42. [SOLVED] code for copy and paste
  43. [SOLVED] Re allocate Named Range addresses
  44. New to Macros - file naming issue
  45. Save active sheet only as pdf + Increment the invoice number + print active sheet
  46. Creating an xml file from each row in excel
  47. VBA Error - Missing 4 columns Data after copying
  48. [SOLVED] When using open text file how to tell if the file existed, or a file was created?
  49. Adding comboboxes in a loop
  50. File folder to single spreadsheet
  51. Get the heights related data in row D
  52. [SOLVED] Extract the formulas of each cell in range - VBA
  53. Populating PDF document with Excel vba
  54. Excel Function -Address
  55. [SOLVED] Select from Cube Through VBA
  56. Customised spell check in VBA
  57. [SOLVED] ActiveSheet.Previous.Select
  58. [SOLVED] need help gettng macro to run faster! please!!!
  59. Combine Multiple Worksheets w/ Different Headers Into One Worksheet
  60. VBA: Match string and color substring
  61. [SOLVED] VBA: Chart with Combobox
  62. Copy and combine files using VBA
  63. [SOLVED] Unmerge cells across rows only not across columns
  64. [SOLVED] Message in Every Cell
  65. VBA code for extracting report from Outlook Mails
  66. Adding functionality to an existing Excel Workbook (example pictures included)
  67. How Do I Filter In Excel Using TextBox?
  68. Compare values inside the range (sheet1) and copy the row to new sheet (sheet2)
  69. [SOLVED] Summing of columns into specified cell loop
  70. Help in Pivot
  71. [SOLVED] UserForm VLOOKUP to get Data and Change one Column
  72. pivot table - sort items with different order for each parent item
  73. Auto Save excel file to another Computer on the network
  74. [SOLVED] Help with updating formula's with VBA
  75. [SOLVED] loading a variant array
  76. [SOLVED] Help with code on language translation file
  77. [SOLVED] Adding a Scroll Option to The Text Boc Functionality
  78. [SOLVED] Need VBA to arrange data Cell adress data please!!
  79. [SOLVED] Macro to Set Page to Print in Particular Range & Adding a Company Logo
  80. data transfer
  81. Formatting, Highlighting Travel Times Conflicts
  82. Need VBA to create inputbox for multiple values & filter multiple columns
  83. [SOLVED] Text Size Issues in Text Box
  84. Macro to copy excel recordset and insert in to Database based on a condition
  85. [SOLVED] Rename text file with new name
  86. Userform- Populating Dependent List Help
  87. [SOLVED] Progress Bar for macro
  88. VBA - SAP 'Save As' dialogue box
  89. [SOLVED] VBA to fill up website form and upload file path via “Browse” buttton
  90. Macro to Copy certain WS's based on Key to a New WB and email
  91. Code suggestions required.
  92. Significance Testing Macro
  93. [SOLVED] Loop through column data and delete or copy based on value given
  94. Labor Tracking / Time Tracking
  95. [SOLVED] Project Planner Not Working
  96. [SOLVED] How to export and save each worksheet as new workbook in Excel?
  97. Help with pulling names from online database
  98. [SOLVED] IF, AND, OR Nesting - Part of it not working
  99. [SOLVED] MACRO: SaveAs Cell Value File Name (Pull Two Cells within Worksheet as File Name)
  100. [SOLVED] Module Level Variable Loses Value
  101. [SOLVED] Sort by row based on column value
  102. Updating Google Calendars from a Google Spreadsheet
  103. [SOLVED] How do I set passwords and how to save as a certain name for a file
  104. File size reduction
  105. [SOLVED] Alternatives to MINIFS (Minimum IF's)
  106. Required Email generated with signature and attachments
  107. VBA Macro to copy multiple charts from one excel file to a word bookmark locations
  108. Import data from different files and sheets into file with corresponding data cells
  109. [SOLVED] Array limits?
  110. Open all CSV files in folder, and merge to one master file.
  111. [SOLVED] Copy range to blank cell
  112. [SOLVED] Remove symbol
  113. [SOLVED] Extract part of a line and paste in another cell
  114. [SOLVED] Create 2 Dimensional Array from "For" Loop
  115. Find out row and column range
  116. Vba Compile Error :(
  117. Get (some of) Excel Clipboard contents via Windows clipboard "XML Spreadsheet" format
  118. [SOLVED] Angles between 2 lines
  119. [SOLVED] Modified a function that is called in another function, now getting runtime error?
  120. [SOLVED] Save Outlook attachment into an Excel cell, as OLEObject in VBA
  121. [SOLVED] Pull specific data based on If statements
  122. [SOLVED] Handling Formula Errors & Formula Length Limit
  123. Subscript out of range
  124. VBA to update a table from another table
  125. Run macro on all files
  126. [SOLVED] Split function in vba
  127. excel vba macro to apply filter multiple column using header names
  128. userform icon in taskbar problem in win10 office 2016 bit 32
  129. [SOLVED] need macro added to current to automatically move to next row for next search and
  130. [SOLVED] Need help with Question, is it possible to Call modules to work or loop through?
  131. [SOLVED] Select working(Active) range with mouse
  132. vba adding image after clicking on the textbox
  133. [SOLVED] VBA function to return MySQL Data
  134. Help with filter by date
  135. [SOLVED] Break up column A content between column A and B
  136. Find and Change Values
  137. [SOLVED] Format Issue
  138. VBA code running too slow in Excel 2013
  139. [SOLVED] VBA code attach an excel file to outlook with a variable file path
  140. Autofilter failed
  141. [SOLVED] VBA Code assistance to separate a workbook into several different files.
  142. Function to update a cell in another worksheet giving #1004 error
  143. [SOLVED] Running Macros from ComboBox with Items from a Range
  144. VBA: referencing cell in one worksheet and using it as range start for another sheet
  145. Reading and Writing to dat file via forms
  146. [SOLVED] VBA code to cycle through sheets
  147. [SOLVED] How to send email in excel using content in word as email body
  148. [SOLVED] Take out space
  149. [SOLVED] Convert to a number
  150. [SOLVED] Copy and Move files to existing Sub-folders based on filename/Sub-folders's Name
  151. Change marker size for all series in a plot (VBA)
  152. VBA To Check That Value Appears In Single Cell Range Before Starting Macro
  153. Run-Time error "7" out of memory
  154. Compare two strings for similarity or highlight differences in Excel
  155. [SOLVED] How to Send a HTML Email using Word Email Template using Excel Macro
  156. [SOLVED] Simple for each loop problem
  157. Trying to copy a macro into another workbook
  158. Can you speed up my vba that copy and pastes the header amongst worksheets?
  159. [SOLVED] Auto Save excel workbook every 5 minutes
  160. Subscript out of range
  161. [SOLVED] Looping through ActiveX checkboxes and adding items to ActiveX List Box
  162. [SOLVED] Highlighting a cell if there is a match with another cell
  163. [SOLVED] Pivot Table Error with VBA Code
  164. VBA Use hidden cell to run IF Statement
  165. [SOLVED] Populating colums based on cell value and conditions
  166. [SOLVED] Two rankings
  167. Empty a Module within Excel 2016 …
  168. Disable Overtype / Insert Ability in VB Editor for Excel 2016 …
  169. Add Data Field in Pivot Table
  170. Export all the sheets in excel to images individually files
  171. [SOLVED] vba help on vlookup
  172. [SOLVED] Need help duplicating a row (if not already duplicated)
  173. [SOLVED] VBA FILTER
  174. [SOLVED] VBA VLOOKUP ON Historic trades
  175. Search string in two columns in different excel sheets and copy the matching data
  176. [SOLVED] Procedure Too Large - Compile Error
  177. [SOLVED] Sort/ transfer data
  178. USER-FORM FILTER DATA EDIT
  179. VBA Conditional Formating
  180. modifying function cohort/matrix of ratings migration
  181. Vertical Column with possibility to filter
  182. [SOLVED] vba Double for each Loop combining task
  183. VBA code for lookup table
  184. MSO File Picker Help
  185. [SOLVED] #Name? error for TextJoin UDF
  186. VBA Macro - Use relative ranges to graph
  187. [SOLVED] VBA code mysteriously timing out
  188. [SOLVED] Searching with recursion
  189. [SOLVED] Unzip files to a folder udf
  190. Move cells to another worksheet
  191. Macro to convert from Paste Bottom-Up to Top-Down?
  192. VBA code in Cash Flow forecast
  193. [SOLVED] Need help with Do While Loop or If this AND that then....
  194. [SOLVED] Move File to Folder if filename matches foldername
  195. how to make CommandButton1.Rotation = 90 in office 2016
  196. Advance Filter using VBA
  197. Control strings
  198. adding selected rows into a sheet with a specific selection
  199. vba help to copy specific colulmn.. from a sheet
  200. If Formula not working as expected
  201. VBA getElementById doesn't work correctly
  202. Macro is not recording sheet protection password
  203. Change Sheet name
  204. [SOLVED] Copy and Paste Macro help please
  205. [SOLVED] Loop thru all sheets and copy a value
  206. Timer + Stop Watch
  207. RTF field in Excel by keeping formatting
  208. [SOLVED] Can't call several subs in a macro
  209. Identify employees late login
  210. VBA If formula help
  211. [SOLVED] Delete zeros
  212. Cell Value Confusion.
  213. [SOLVED] Macro To copy and paste data from a list to corresponding worksheet and cells
  214. create and store pdf, attach to email and send, with loop
  215. Subscript out of range and SaveAs Method error
  216. Quote Generator - Advice
  217. [SOLVED] sum of variable range stop working
  218. Trying to copy all sheets into one combined sheet
  219. VBA Help, to Pick first Column Data and its file name
  220. [SOLVED] is it possible: If Me.Controls("CommandButton" & i).clicked
  221. [SOLVED] Shorten loop using boolean
  222. Getting Problems in Making a Query from SharePoint
  223. VBA code to delete rows based on value
  224. [SOLVED] FileSystem Object, Folder.Files.Count Does Not Match Files.Item Count
  225. [SOLVED] For Loop does not seem to be working
  226. VBA Code to Run Other VBA Codes in Multiple Workbooks
  227. Dividing data records fairly into clients based on categories and amounts
  228. [SOLVED] Monitoring Remote Workbook for Changes
  229. [SOLVED] How to display a chart on a certain position (e.g. centre of screen).
  230. What are your favorite Excel VBA automation success stories?
  231. Vba code for partial transpose
  232. [SOLVED] Help with formula please
  233. [SOLVED] how can i save userform settings
  234. Parsing data to several sheets
  235. [SOLVED] Countif using arrays
  236. [SOLVED] IF then
  237. [SOLVED] Blank cell
  238. [SOLVED] VBA code to paste data to a row with today's date in column A in another sheet
  239. [SOLVED] Insert Pics Macro Not Working on All Cells unless name manually typed in
  240. [SOLVED] Selection not displayed when combobox item is selected
  241. [SOLVED] VBA check if a specific value has been entered into range
  242. Subscript out of range and SaveAs Method error (Revised)
  243. Encrypt password for database access
  244. select radio buttons in IE
  245. Using RANK on a range of data - need an exception
  246. [SOLVED] combine selected worksheet into one worksheet
  247. Cell locking macro not working
  248. Need code to merge PDF files in a folder using adobe acrobat
  249. A neat timesaver for Immediate ("debug") Window - abbreviations
  250. Rewriting Referenced Data for VBA Pivot Table