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. VBA - HIDE/UNHIDE Rows Based on Output of a Formulated Cell
  2. (Single Workstation) Error, how to reset? Macros via Ribbon UI aren't firing...
  3. Specify which folder to open when using Get Open Filename
  4. Autocomplete value entered into a cell from a list in another workbook
  5. [SOLVED] Remove duplicates from Rows with the last Row only as reference
  6. Quick way for removing rows
  7. How to test for characters in a specific set?
  8. [SOLVED] Combine two macros on the same sheet
  9. [SOLVED] Compare Multiple Columns in Multiple Sheets and Merge differences
  10. Adding a unique watermark to a PDF from Excel
  11. Need help formatting an email generated from excel to outlook.
  12. EXCEL 2013 DEPENDENT CELLS
  13. find min value of specific designation
  14. Copy and paste multiple data from Excel to Internet Explorer
  15. VBA - Run same code for each row but increment values?
  16. Populate the text2 box with the expiration date of 30 working days
  17. Store specific rows in an array
  18. [SOLVED] One Function: Different Formulas for Different Inputs
  19. Refreshing connection
  20. Copy Filtered Visible Data from one workbook to another workbook with Filtered Field
  21. [SOLVED] Conditional Formatting and Data Validation.
  22. Is it Possible to Run Goal Seek on array elements within VBA?
  23. [SOLVED] Flexible address for autofill
  24. Table Creation in EXCEL
  25. Unknown external link to macro-workbook problem
  26. [SOLVED] Pivot Table Flexible Source
  27. List related information comparison, based on list matching
  28. time format a text box in excel userform
  29. Extracting excel files only from 3rd subfolder and only from certain folders
  30. Need help with VBA and copying rows
  31. Transferring Data from Outlook to Excel
  32. Drop time info from CSV import
  33. [SOLVED] How do you create nested classes in VBA Classes in Excel?
  34. Need help in accelerating a process(too many loops)
  35. Copy data from Multiple WBs without Duplicates
  36. window of search in the userform
  37. ExcelVBA - Opening files with certain conditions
  38. [SOLVED] Excel VBA : how to merge cells in winword table with for... next
  39. Fast Data Search Method With Userform
  40. [SOLVED] Data Replacement
  41. Get table of information from website
  42. [SOLVED] Check if cells match but ignore the spaces.
  43. [SOLVED] Need Help passing a userform.texbox object to a sub
  44. [SOLVED] help with If statement that counts
  45. [SOLVED] VBA macro for deleting not matching values
  46. [SOLVED] Excel VBA : How to break the file Path
  47. Excel VBA: Consolidating data with existing data each time macro is run
  48. VBA Code - Insert Pagebreak in Selected Cells (Range)
  49. [SOLVED] Find/Replace in Excel
  50. [SOLVED] Excel Button IE Automation
  51. [SOLVED] Need Help for pasting data for 2 columns instead of 1 column
  52. Copying text from Word to Excel with VBA
  53. Vertical line pointing to fixed Date
  54. Determine ScaleHeight of an image
  55. Highlight missing or duplicated cells
  56. VBA Script to fill in missing data
  57. Best way to capture digits to left of decimal place?
  58. Conversion of formula to userform or button
  59. [SOLVED] Hex Colors Display in Excel Wrong - RGB
  60. acceleration of a macros formation of data on new sheet
  61. [SOLVED] Retrieve data by downloading a text file from a site
  62. Runtime Error 1004: Attempting to Mirror Cells
  63. VBA access embedded window data from html
  64. Copy from Merged Cell to individual cell
  65. Ribbon tool
  66. Copy from different workbook
  67. VBA code just need one line...?
  68. Not able to access a text field using getElementbyID
  69. ActiveX Checkbox VBA Code Help
  70. Based on cell value highlight cell and transfer data from one to another sheet
  71. Convert date format
  72. Print PDF on Back Side of First Sheet of Excel File
  73. Determine the position of a screentip
  74. VBA Code Assistance
  75. [SOLVED] Msg Box restarting every 5 seconds
  76. [SOLVED] Formula Error (Not using VBA Code)
  77. populate userform listbox with pivotRowField items
  78. [SOLVED] Reload combobox contents after saving file
  79. VBA Help, Getting error: 'That name is already taken. Try a different one'
  80. [SOLVED] Macro is being driven on different worksheets
  81. [SOLVED] Finding Angular Misclosure and then Balancing Angles
  82. VBA help in coding
  83. Get unique items and sum total on userform
  84. Open Zip file with many other named files and months within folder
  85. MAcro Help
  86. Macro to Unhide Column, Print, Hide Cell
  87. [SOLVED] Run-time error '1004': Method 'SaveAs' of object'_Workbook' failed
  88. How can I copy 2 sheets and Paste everything but the Formulas
  89. VBA listbox change event
  90. using public variables in userforms
  91. [SOLVED] Sumproducts problem
  92. [SOLVED] Split some sentences by 'vbKeyEnter'
  93. userform help
  94. [SOLVED] Worksheet_Change
  95. Copy value on a monthly basis from a website and update excel workbook
  96. [SOLVED] Image control and load picture
  97. [SOLVED] Selected Sheets Count
  98. How can I compress the all winword images by Excel VBA coding
  99. [SOLVED] Removing duplicates from cells across rows, not down columns, without deleting rows
  100. [SOLVED] Need Help restructuriing Macro that highlights dups to highlight also partial
  101. 2 issues with Macros (Printing Pages & Not copying data when worksheet is Blank)
  102. [SOLVED] Identify unique items in column and delete row
  103. [SOLVED] Way to speed up this newbie's simple recalc/copy/paste loop?
  104. [SOLVED] Mac excel shortcut to select all rows till end
  105. Macro to Automate a school timetable workbook
  106. textbox format
  107. [SOLVED] Why does the "Format shape" window appear when i run a macro?
  108. VBA to Copy and Past from One Sheet to Another
  109. Changing values based on offset values
  110. Vlookup Error with Negative Value Range
  111. Error Trying to send email via Excel
  112. [SOLVED] Need help gettin this macro to run faster, Please!
  113. Overriding Disable copy/paste code
  114. [SOLVED] transfer of information from identical excel files and identical sheets of accumulati
  115. [SOLVED] VBA Regex
  116. [SOLVED] ListBox1_Click to select an item on a worksheet
  117. Reading 1st row of a CSV file into Array without opening it
  118. [SOLVED] VBA macro for comparing 4 columns and highlight
  119. Transform data from vertical to horizontal
  120. Changing Combo Box Selection Value
  121. Show column heading and corresponding value based on dropdown selection
  122. range: from active cell to last cell in current column (discontinuing)
  123. [SOLVED] Sorting Columns into Tables
  124. [SOLVED] Insert picture name in worksheet change
  125. vba loop to find and change value in textbox on userform
  126. Decode Base64 to String in VBA to Excel cell
  127. Copy & Paste Dynamic Range to New Worksheet
  128. [SOLVED] Excel VBA refer to a userform by variable to address it
  129. [SOLVED] Coding Help for Range Calculations
  130. Runtime 91 error on userform populating one input box on webpage
  131. [SOLVED] Replace Number In A Column With A Different Number
  132. Function Error
  133. VBA to merge / unmerge identified rows when target is used
  134. [SOLVED] IF formula in Macro for entire row
  135. Facing problem with update the record
  136. [SOLVED] datevalue error - #Value
  137. Custom Sort Parts List - VBA
  138. Interact with Internet Explorer open tabs - VBA
  139. Consolidating multiple worksheet into one by finding Column Name
  140. [SOLVED] Multiple Excel sheets update
  141. [SOLVED] DDD.MMSS to DDD-MM-SS
  142. [SOLVED] Copy values from loop and paste in different worksheet
  143. Gmail Login failed (Web Scraping)
  144. [SOLVED] Help getting a Macro to work!!
  145. How to put timestamp on a cell using a button VBA
  146. Listboxes with filtered data > import data from table to userform?
  147. Cell Anchoring in VBA??
  148. [SOLVED] Time Loop
  149. VBA - help assigning varibles
  150. [SOLVED] Compare data between two sheets
  151. IN Statement in VBA
  152. [SOLVED] no idea
  153. VBA: VLOOKUP with LOOP
  154. Positioning labels within chart
  155. MACRO: IF THEN Statement (Multiple Criteria Match then Copy)
  156. Add additional step to macro
  157. help with dynamic offset
  158. Outputting to more than one cell at the one time in VBA
  159. [SOLVED] VBA: Index/Match
  160. Copy row to exisiting tab and then delete
  161. [SOLVED] Copy entire row to new tab if a cell contains certain text
  162. Limiting the number of checkboxes to be selected
  163. Create if statement: if value exists then create new sheet
  164. [SOLVED] Autofilter in Macro not working!
  165. Change file extensions
  166. VBA Print to PDF Button code issues with multiple users
  167. SubTest Help for debugging
  168. Macro Formula with dynamic ranges
  169. Prevent Copying Worksheets
  170. Please help me with this excel generator
  171. Word Document Data to Excel Spreadsheet code/macro
  172. Consolidate multiple workbooks and worksheets from a folder
  173. How to unzip with VBA?
  174. Mapping userform checkbox value to Outlook
  175. Help is multiple nested IF statements using range objects
  176. Filename Variable
  177. VLOOKUP, INDEX and MATCH formatting problem
  178. [SOLVED] MERGE 2 DİFFERENT VBA CODE
  179. [SOLVED] ActiveX Label
  180. [SOLVED] Code That Creates Names based on the Sheet Name
  181. download company URL's & company names across multiple pages from web (Web scraping)
  182. VBA REPLACE CURRENT CELL WITH CURRENT MONTH AND TEXT
  183. Last Occurence of last month Transaction using Index sumproduct
  184. Help me for ListBox ListFillRange
  185. [SOLVED] Need Way to move certain data when certain column is updated
  186. Question about Copy and paste DataObject in excel worksheet
  187. VBA Import Text Line by Line to formatted Cells
  188. Save SVG image as png or jpg format from a website
  189. [SOLVED] Combobox question
  190. [SOLVED] Procedure for merging common values in same column
  191. could not get single (last) element while looping through class name (web scraping)
  192. [SOLVED] identify Highlight Overlap dates
  193. Parsing websites
  194. [SOLVED] Change multiple Form Control Button captions from a list on another worksheet
  195. Use conditional statement to sum column values and paste to new worksheet
  196. [SOLVED] Highlight two sets of cells based on selection.
  197. Shuffleboard tournament math
  198. [SOLVED] Ranking the rows without sorting
  199. VLookup to skip blank cell
  200. Create New Folders - Input Box
  201. [SOLVED] Index Match Over Multiple Worksheets
  202. Merge Only Visible Worksheets
  203. Passing selections from a drop down box to loop in sub procedure
  204. [SOLVED] Importing data from Word to Excel in non-continuous fields
  205. [SOLVED] Listbox Multiselect issue
  206. [SOLVED] code not calculating storage charge correctly
  207. Highlighting row containing specific word in specific column
  208. Find Max Value in one worksheet and return the value to a cell in another
  209. I simply can't do it alone (simple VBA macro to search and find), please help!?
  210. [SOLVED] Download Attachment from Email and extract Data
  211. [SOLVED] Autofilter problem
  212. List Box - Application.run Macros
  213. What is the best way to combine multiple workbooks into one?
  214. Count down timer help
  215. [SOLVED] Separate files and save them in PDF format
  216. [SOLVED] Concatenate Two Cells in a third cell
  217. Pivot table to refreash and ask for new filter dates
  218. Sleeper: Error in VBA Excel
  219. "For Loop" to Change "Chart title" based on sequential cells
  220. VBA Classes
  221. Merging of files where columns are the same
  222. How to relate. OPTION BUTTONS
  223. Loop to concatenate cells
  224. Copy Highlighted Cell to Another Worksheet
  225. [SOLVED] Formula to Display Several Strings of Text in a Cell
  226. [SOLVED] List Box - Reset Button - Search Filter Clear
  227. Excel And Perfmon
  228. Macro for removing 2 letters word
  229. [SOLVED] Macro not copying down lines
  230. Creating a message box with multiple options
  231. [SOLVED] Public procedure to sort similar rows
  232. Group data on one table based on information in another table
  233. Manual calendar
  234. Active Cell and Timers - Fix References
  235. [SOLVED] Help sorting numbers in listbox in ascending order
  236. VBA Find & Replace based on cell reference within a range
  237. [SOLVED] No Pair
  238. Select different cells in several sheets.
  239. use excel vba to select an item in a Kendo grid in IE
  240. Userform with Combobox launched from Worksheet
  241. How To Detect Click On Zoom In Status Bar?
  242. Copy Range Until Last Cell With Data
  243. [SOLVED] MouseMove event for disabled controls.
  244. Excel SmartArt Organizational Chart - Name and Title
  245. Interfacing with local 'virtual' server
  246. [SOLVED] Find Match, Copy/Paste to a closed worksheet in workbook
  247. [SOLVED] help with validation
  248. VBA code fastest highlight of unique values
  249. How to copy rows from a sheet to ather sheets in the same workboouk with criteria
  250. Split Workbook Into Multiple Workbooks