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

  1. Audit Log - track changes to all cells in a workbook
  2. Model cell colours
  3. Need a formula to show the cell coordinates
  4. Copy random numbers and sort.
  5. VBA to do something 5 times then go back
  6. Need some help pls. How to color cell A if cell B is an even number
  7. Loop through worksheet and create a new column based on cell values in another column
  8. Extract string from multiple files using vba
  9. Need help with homework problem
  10. Need help with this review problem
  11. [SOLVED] Store individual cell contents in arrays, match terms and highlight when found
  12. slowdown in performance when I write the result of the macro in cell
  13. VBA Error Referencing Spreadsheet
  14. Tool to automatically feed database
  15. MULTIPLE PDF TO SINGLE EXCEL WITH OVERWRITE
  16. VBA Error Referencing Excel Spreadsheet
  17. VBA copy data to matching workbook
  18. Find row number of maximum value found in a given column?
  19. VBA Mails workbook as attachment - need to remove path from filename
  20. Help Importing XML files - VBA
  21. Type mismatch error, code previously worked
  22. User cannot select items in a Listbox
  23. Quick Help with adding "MSG Box" into code
  24. HELP - Code not working (My old boss has retired and this was his code)
  25. Calculating elapsed time between starting and closing excel
  26. VBA Macro Progress Message
  27. VBA code of Excel 2013 is not working in Excel 2010
  28. [SOLVED] Start Looping Through Range from the Middle
  29. Excel 2002 to Excel 2013
  30. [SOLVED] Copy Current Row and paste to the next couple hundred rows
  31. VBA code is not working in win7_64
  32. Log in on a website thanks to VBA
  33. Choices from User Form
  34. [SOLVED] Combining workbooks with varying names
  35. [SOLVED] Automate - manual made macro
  36. Make Tiny URL link of hyperlink in cell
  37. How to speed up my macro?
  38. Importing data tables from the WEB
  39. Fill in form on website and submitting multiple values in new tabs
  40. Alternative to copy / paste
  41. How do I disable a macro button if file name is a date?
  42. String comparison and highlight... a bit different requirement.
  43. Scrape data Using getElementsbyTagName NOT WORKING
  44. Downloading pdf using vba, IS IT POSSIBLE?
  45. Miror margins
  46. Incremental numbers with a special format
  47. [SOLVED] Macro to Create Individual Workbook and Remove Colors
  48. Sum Column B based on Column A and format it
  49. Personal.xlsb ..... or ?
  50. difference between
  51. [SOLVED] Macro Button Color
  52. Need help fixing a VBA code to show the correct date when time is being converted.
  53. MsgBox Display Offset Value
  54. Populate a list box with worksheet names
  55. incorporating Bank Holiday into formula
  56. Sample post so I can look at some code
  57. [SOLVED] How to replace/move data from ons sheet into a workbook in a specific sheet.
  58. export to txt file
  59. [SOLVED] Need help integrating checkboxes into existing (simple) macro
  60. another code apart from ( target.address)
  61. [SOLVED] Trying to delete cells with specific terms, Runtime 424 Object Required error
  62. [SOLVED] named range tracking via VB
  63. Navigate in an application thanks to VBA
  64. [SOLVED] Inserting non default signature with picture in Outlook e-mail
  65. [SOLVED] Copy data from sheet to a table (object)
  66. Excel to Email with Attachment (1 line only at a time with button push)
  67. Cut/Paste data, code only works on first 4 rows
  68. Splitting a cell with "/" delimeter and use first part as new line heading
  69. How to find available rows, columns and bits from matrix definition in spreadsheet
  70. HELP: Find, Filter, copy and then send mail from outlook
  71. Excel crashes during VBA cell copy
  72. [SOLVED] Formatting a date in word document from excel using VBA
  73. Variable type change for XValues in charted data
  74. Overlap Dates
  75. Hyperlinks created on sheet (not VBA) work for some users but not others - Any Reason
  76. Web Browser Automation: favorite all items on page, move to next page
  77. [SOLVED] Update code for inserting data in all closed file in folder
  78. Looping through txt file and returning a section to excel
  79. [SOLVED] Running a macro based on a list
  80. pass data from excel to web form
  81. Search external file for a value then print each row of data found using VBA
  82. SCHEDULE help please
  83. [SOLVED] How do I combine two statements in Excel?
  84. [SOLVED] Delete all data on sheet except certain range
  85. [SOLVED] How to get my macro to click a button in a dialog
  86. Pass value from excel to IE form
  87. Macro to copy Codes in rows when Criteria's are met
  88. HELP WITH MACRO PROBLEM
  89. Adding subfolders into routine
  90. Please help me with
  91. Help Needed: Listing Files & Folders-VBA Coe Error
  92. VBA With Excel to Merge PDF Based on Filename Oldest to Newest
  93. [SOLVED] Set default value of combo box
  94. [SOLVED] entries in column A
  95. Table Changing Name After Macro
  96. VBA to sum data on another worksheet
  97. [SOLVED] AfterUpdate not triggered
  98. VBA Data from an access database using a variable
  99. CreateObject("InternetExplorer.Application")
  100. [SOLVED] CheckCompatibility statment
  101. Function that uses a variable number of arguments
  102. how to track precedents and dependents.
  103. [SOLVED] Problem with code
  104. vba subtract time from date
  105. Filtering multiline data prior to dumping into cell
  106. In a cell Vertically entered mobile number , I want to extract all mobile number.
  107. Search and Paste
  108. [SOLVED] Add default Outlook e-mail signature with Excel without displaying e-mail first
  109. Pass Sheet Range to a SelectionChange Event
  110. [SOLVED] Parsing XML Help
  111. [SOLVED] Please help with Array comparison to trigger email
  112. [SOLVED] VBA to filter a column starting at row 2 to Lastrow
  113. Output Required Horizontally in Excel Sheet separated each by semi colon.
  114. Deleting ony those rows in excell sheet in which entire row cell is blank .
  115. 32x to 64x error
  116. Gradation - Quantile Performence
  117. In an excel sheet some column cells are blank then corresponding blank cell
  118. [SOLVED] Combine All Workbooks from One Folder to One Master file
  119. Copy unique column values to a new column in a different worksheet
  120. [SOLVED] Extracting Home Value Estimates from Website
  121. Import data from Word to Excel - School Assignment
  122. loop not working for next file in same folder
  123. Importing from Web problems
  124. vba to clear values in an excel pivot table
  125. offset one row
  126. [SOLVED] Insert New Row issue...doesn't work when the worksheet is protected
  127. IF and Then range based upon number rather than string - code inside. Help!
  128. VBA slow reading back from database
  129. [SOLVED] Split Function Help
  130. How to call onClick Javascript function in VBA
  131. Find Date an return row number
  132. Insert columns to multiple sheets based on list
  133. VBA Date
  134. Userform to Find Cell from ComboBox Value and write to Adjacent Cells
  135. Excel Form - Displaying 2 Digits (Zero fill) and Reacting to Forward/Back
  136. [SOLVED] Copy, Paste, and Repeat Down Based on Adjacent Cell Value
  137. [SOLVED] Edit Cells By Comparing Value
  138. [SOLVED] Adding Two Arrays in VBA
  139. Combining matching values
  140. [SOLVED] Help defining and building an array and using VLOOKUP
  141. VBA Macro FUNCTION To Sum Up Values of multiplier of muti-Columns
  142. [SOLVED] Email from excel-VBA
  143. [SOLVED] command button
  144. [SOLVED] Sort names NEWBIE
  145. [SOLVED] Cell color
  146. [SOLVED] Help with loop
  147. Ecel crashes when code initiates
  148. [SOLVED] transposing information between 2 sheets
  149. [SOLVED] Conditional Search Copy Entire Row to next row on match
  150. [SOLVED] Populate Treeview with specified Windows Directory & Sub-folders/files
  151. Comparing cells
  152. [SOLVED] Text instead of #N/A
  153. [SOLVED] Removing Special Characters
  154. [SOLVED] Shift select data
  155. [SOLVED] Chart in chart sheet - assign array values
  156. Sort names
  157. Paste multiple cells into one
  158. VBA Code for hiding rows based on a result of formula
  159. Data Validation - Multiple Criteria
  160. Copy entire row
  161. generate work schedule
  162. Create worksheet level event in macro
  163. Can't Scroll Down Dropdown List
  164. Create CSV files with Multiple sheets columns
  165. [SOLVED] F8 Key suddenly does not work
  166. [SOLVED] How to rename the .XL file with the name of the .CSV file
  167. [SOLVED] Inserting a block of rows at the end of a register
  168. Adding active spreadsheet as attachment to email
  169. VBA to search given cell value in given folder path
  170. [SOLVED] SelectSingleNode
  171. [SOLVED] Treeview - Sort Nodes Alphabetically (Like in Windows)
  172. [SOLVED] Macro to generate summary based on Dates
  173. Extract partial value from cell
  174. [SOLVED] Vlookup on another sheet
  175. Calculate hours
  176. COPY PDF FILES FROM HYPERLINK LIST
  177. [SOLVED] Macro to loop through data in Master Worksheet
  178. How to set a loop around a script?
  179. Split Multiline Cell text Into Multiple Rows
  180. [SOLVED] Values from 2 collumns into 1 column
  181. FindAll on sheet3 then display in sheet1 user form
  182. Process All CSV Files In SubFolders
  183. Price consistency calculation in Excel
  184. Display current time on a form in a Mac
  185. content list & rename
  186. GRAFS , PIVOT SAVE AND SEND MAIL WITH ATTACHMENT PDF FILE
  187. erase array value partially
  188. Double filter in VBA code
  189. VBA change data source Pivot Table
  190. [SOLVED] HELP! Saving exported spreadsheet and naming the file based on a cell value VBA
  191. I need help to enhance my code...
  192. [SOLVED] Code needed to organize data
  193. [SOLVED] Multiple arguments used in cell function
  194. Force User to enable macro and still save
  195. [SOLVED] Help with matching in VBA
  196. [SOLVED] Copy Table To New Sheet
  197. [SOLVED] VBA EXCEL Range syntax
  198. Website automation by VBA
  199. [SOLVED] Doesn't wait for the response to Question
  200. Auto fill/graph on button click
  201. [SOLVED] I am looking to see if there is a more efficient way to write a code
  202. [SOLVED] Value to stay visible
  203. [SOLVED] Add a row with more than 10 columns to a ListBox?
  204. Fill A AZ
  205. [SOLVED] Detecting Change in Value
  206. Directory Issue
  207. [SOLVED] Data validation - Team Name, Thread and Sub-Thread
  208. [SOLVED] Help with Error Message returning the Row and Sheet that contains the error
  209. Saving File Gives Error Excel VBA
  210. How to disable Heading Control, via VBA in the Ribbon, View Tab
  211. [SOLVED] need help with regex
  212. [SOLVED] Need help to copy the UsedRange
  213. EXCEL/VBA macro for print address wrong spreadsheet in wrong workbook
  214. [SOLVED] Compare two cell in two columns and present in new column
  215. Select a Range based in a criteria, copy to a new workbook and attach in Outlook
  216. [SOLVED] handling .txt files with 4mio lines (610 mb)!
  217. VBA to Concatenate Multi-Value Cells
  218. Create multiple Free text Search Tabs in Excel
  219. Email With attachments, Changeable users
  220. [SOLVED] sick record
  221. [SOLVED] Match two different columns
  222. [SOLVED] Need to loop until last cell need to modify
  223. Refresh Spreadsheet data and Pop-up message based on critera
  224. MY LAST USF BY VLOOKUP VBA
  225. [SOLVED] in cell forumla
  226. [SOLVED] Autofill certain cells with VBA
  227. ShowWindowsInTaskbar in 2010
  228. Generate Outlook E-mail via Word using VBA, Formatting Issue
  229. code to copy content to adjacent cells based on a cell value
  230. How to get the data back from website to excel
  231. Input From TextBox to Web Site
  232. Copying and pasting a dynamic range
  233. VBA "Error loading DLL" wrong PowerPoint reference (Excel 2010)
  234. [SOLVED] Need help to autofil with VBA
  235. Display outlook mail from VBA
  236. How to write myConnection(id)
  237. Anyone can help?
  238. Intersecting range and array
  239. [SOLVED] AutoBackup / Make 1 extra copy of my workbook
  240. [SOLVED] Optimize Macro
  241. [SOLVED] Advancing cell referencing each month
  242. [SOLVED] Macro to make userform appear when clicked anywhere in Column D
  243. Importing a Portion of a .txt file by pattern - Please Help
  244. Improving Macro
  245. Excel Macro Procedure Too Large Error - Help
  246. Help with userform
  247. Show Installed Digital Certificates programatically using a Macro
  248. Can someone help on my code enhancement
  249. Copy/Insert union of subranges into existing worksheet
  250. Adapt code to move files to a subfolder of the same name