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