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

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