Log in

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