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. Search multiple columns in another Workbook for value (25 replies)
  2. Looping through a range and assigning the row # to a variable when found (1 replies)
  3. Delete Workbook_Open code before Saving (0 replies)
  4. Drop Down list Show/hide rows (3 replies)
  5. copy cells with just text not the formulas (2 replies)
  6. Current dates in cells C2:U65000 when values in cells range A2:A65000 changes (7 replies)
  7. Delete Rows that meet a Criteria (1 replies)
  8. vba code to find row base on some conditions without using a loop or filter (3 replies)
  9. Excel exceeding maximum number of connections to outlook (3 replies)
  10. Rolling Average in VBA with multiple columns (7 replies)
  11. [SOLVED:] Exporting Multiple Sheets as Excel & PDF (7 replies)
  12. Ontime vba opens another workbook that is not requested (42 replies)
  13. Square to link (5 replies)
  14. [SOLVED:] xlsm or xltm file extension (4 replies)
  15. Before Print Issue (2 replies)
  16. Breaking out a pivot table to new workbooks (6 replies)
  17. Copy fields from workbooks to a master workbook (2 replies)
  18. repetative code (11 replies)
  19. [SOLVED:] Offscreen print (3 replies)
  20. If Statements in VBA (3 replies)
  21. [SOLVED:] Conditional Formatting with three criteria (2 replies)
  22. VBA to Test Outcomes of Drop Down Selections (4 replies)
  23. [SOLVED:] Finding last row with data to send Mass Email (4 replies)
  24. [SOLVED:] All of code is not being executed (1 replies)
  25. error 1004 unable to get pastespecial property of range class (6 replies)
  26. [SOLVED:] Find values within strings from a predefined list (6 replies)
  27. [SOLVED:] [Excel VBA] Run-time Error 91 : Object variable or With block variable not set (0 replies)
  28. [SOLVED:] Advance Filter Criteria (3 replies)
  29. Poor display in listbox (4 replies)
  30. copying row + 1 row above and copying row + 1 row below (6 replies)
  31. [SOLVED:] Colour Entire Row Base on the Value of Two Other Cells (75 replies)
  32. Complicated Macro Help Required! (4 replies)
  33. [SOLVED:] Excel Macro - Copying data from one workbook to another (16 replies)
  34. filter response (convolution) (6 replies)
  35. Replacing text in the formula in one part of a worksheet (1 replies)
  36. For Existing and New files: CREATE & UPDATE file on different USB drives (6 replies)
  37. [SOLVED:] Search String in Text Files (6 replies)
  38. [SOLVED:] ExportAsFixedFile Error (3 replies)
  39. Looking for a way to export sheet with pictures/shapes (0 replies)
  40. [SOLVED:] Storing wav files in a workbook. (7 replies)
  41. [SOLVED:] Delete First Duplicate Row (2 replies)
  42. [SOLVED:] Excel VBA Automation with the use of .BAT File - Task Scheduling your work (9 replies)
  43. Maclaurin Series (4 replies)
  44. [SOLVED:] Returning Row number in data sort (4 replies)
  45. [SOLVED:] Re-arrange a columns data without sorting. (7 replies)
  46. [SOLVED:] Symbol - VBA reference - Need help! (2 replies)
  47. Unable to capture all the rows (2 replies)
  48. [SOLVED:] Copy matching data from many workbooks to summary workbook (6 replies)
  49. Problems with formatting a scatter chart using macros (0 replies)
  50. How to delete each empty row in a spreadsheet (20 replies)
  51. [SOLVED:] Excel VBA Code to Open a .txt file and loop through every single words (5 replies)
  52. [SOLVED:] Delete Cell contents when data is added to another cell within a range (7 replies)
  53. [SOLVED:] Extracting Date from a string of Text - VBA Coding Help (5 replies)
  54. Lookup from unique data (2 replies)
  55. VBA help! drop down selected - copy and paste data (7 replies)
  56. [SOLVED:] hide, unprotect, unhide, protect (15 replies)
  57. [SOLVED:] Merge Excel Files in Folder into Bottom of Current Worksheet (5 replies)
  58. Find seven columns that come before last column. (1 replies)
  59. [SOLVED:] Saving Selection Ranges on difrant sheets as One PDF (7 replies)
  60. Saving Excel Selection as A PDF document (5 replies)
  61. [SOLVED:] appear pictures in userform (17 replies)
  62. [SOLVED:] Set Integer to a Value (2 replies)
  63. How to concatenate several cells (4 replies)
  64. interpolation (4 replies)
  65. External Links - How to remove user name? (5 replies)
  66. Log date time and user (6 replies)
  67. [SOLVED:] Copy Paste Data from Sheet 1 to Sheet 2 (12 replies)
  68. Excel Userform VBA code to submit to worksheet (3 replies)
  69. [SOLVED:] Excel to return looked up values from drop down list? (8 replies)
  70. add/fix vba reference (5 replies)
  71. Editing text in a SmartArt shape via a drop-down list (3 replies)
  72. [SOLVED:] Summing growing range (4 replies)
  73. [SOLVED:] Need help with a loop (6 replies)
  74. VBA : SEARCHING problem (12 replies)
  75. [SOLVED:] Create different file (3 replies)
  76. [SOLVED:] Macro Autofill with Loop and Delay (2 replies)
  77. Saving Worksheet as PDF (1 replies)
  78. Excel Addin Compatibility Problems with 2013, Invisible ActiveX Control (2 replies)
  79. VBA Code to Rename Folders (25 replies)
  80. [SOLVED:] Hide Unhide with a twist (2 replies)
  81. VBA Excel 2010 - interact with a website done in java (0 replies)
  82. Web selector (2 replies)
  83. VBA web warning messages (0 replies)
  84. [SOLVED:] Finding Duplicate in Long Numbers (17 replies)
  85. [SOLVED:] how to save excel sheet in a text file? (3 replies)
  86. HELP_Excel chart with X and Y values in the same series. (0 replies)
  87. [SOLVED:] Set an object as the outlook inbox (9 replies)
  88. Increase range size by one cell each run (1 replies)
  89. [SOLVED:] Delete Duplicate data (4 replies)
  90. Temp Lock Workbook while form data is submitted to worksheet (0 replies)
  91. [SOLVED:] Macro to copy data based on criteria - Percentage - For sampling (35 replies)
  92. USERFORM COMPLICATED (5 replies)
  93. [SOLVED:] Copying Formulas into a range where blanks exist. (8 replies)
  94. eliminate part of formula via macro (1 replies)
  95. Search for multiple values (4 replies)
  96. VBA USERFORM : listbox show data only ID selected (3 replies)
  97. VBA vertical major grid lines do not want to format as stated below (0 replies)
  98. Extract xml elements from mutiple urls into Excel (1 replies)
  99. [SOLVED:] XIRR Problem (7 replies)
  100. close MAPI session using VBA (0 replies)
  101. Referencing location based on Cell data (4 replies)
  102. Smoothing data (1 replies)
  103. Search and match data from multiple workbooks (8 replies)
  104. Using XMLHTTP to upload a file to API (12 replies)
  105. Sleeper: Copy/Insert union of subranges into existing worksheet (0 replies)
  106. Goal Seek function and Range (2 replies)
  107. Split Pdf based on the sheets state Code by excel/Access vba (0 replies)
  108. [SOLVED:] Listbox and Combobox Problem (1 replies)
  109. Multiple IF's in "Insert function" bar (1 replies)
  110. Need to convert it to Word VBA (2 replies)
  111. Help with multiple values for search (1 replies)
  112. FLIGHT OF USERFORM (4 replies)
  113. [SOLVED:] Upgrading from 2003 to 2013 and sharing workbook. (2 replies)
  114. validating textbox input upon TAB or ENTER (3 replies)
  115. Open new window within current (1 replies)
  116. Input boxes to change row each time (2 replies)
  117. [SOLVED:] Need help naming a worksheet based off another worksheet in VBA (3 replies)
  118. Time Line Chart (1 replies)
  119. [SOLVED:] help on merged cells... (7 replies)
  120. Need help deleting rows based on cell criteria (3 replies)
  121. copy and paste only certain rows macro (1 replies)
  122. [SOLVED:] VBA SUM() with pop-up window to select range (2 replies)
  123. Casting a data field to number (0 replies)
  124. Basic Help (2 replies)
  125. Sheet to array (3 replies)
  126. HTML VBA Help: Cannot Press Search on a website through VBA (0 replies)
  127. Error in Validation.Add - Application define or Object defined error" in Excel 2013 (0 replies)
  128. Rookie: Working with Private Subs (9 replies)
  129. Database/List Manipulation (67 replies)
  130. [SOLVED:] creating a macro to edit protected workbooks (12 replies)
  131. LISTBOX : search by first letter (14 replies)
  132. VLookup from table 1 to appear in table 2 (2 replies)
  133. How to get a list of *runnable* macros (7 replies)
  134. How to import one sheet from Closed file to open sheet (1 replies)
  135. [SOLVED:] Inserting multiple rows based on criteria and copy-paste new data (5 replies)
  136. [SOLVED:] Formula being replaced with result (8 replies)
  137. [SOLVED:] VBA or not? Absolute value question (6 replies)
  138. [SOLVED:] VBA - Create button and his event in a classe (1 replies)
  139. VBA UerForm : Match and Vlookup multi value in combobox (4 replies)
  140. Adding a password to a worksheet converted to PDF (7 replies)
  141. Macro Help (4 replies)
  142. [SOLVED:] ADODB Connection Problem? (2 replies)
  143. [SOLVED:] Computing IRR & NPV with dynamic range (2 replies)
  144. VBA to filter data in a source file using data from another workbook then create new (5 replies)
  145. Working sync update code - need to add some help logging changes made (3 replies)
  146. [SOLVED:] Macro to fill formula in reverse (5 replies)
  147. Ranges (14 replies)
  148. [SOLVED:] Combining Duplicates (9 replies)
  149. Lookup text and insert value (34 replies)
  150. merge by vba (4 replies)
  151. VBA Schedule help (0 replies)
  152. [SOLVED:] picture in userform (2 replies)
  153. Multiple combo box usage (6 replies)
  154. [SOLVED:] Filter based on cell value (4 replies)
  155. VBA in MS Office 2016 (9 replies)
  156. [SOLVED:] How can I populate data from other sheets onto my main sheet, one below the other? (9 replies)
  157. VBA macro for running multiple macros in multiple worksheets in the same workbook! (3 replies)
  158. Disable Protect/Unprotect button on the ribbon (2 replies)
  159. [SOLVED:] Insert values before hiding column (5 replies)
  160. [SOLVED:] Select a found file and open in explorer (2 replies)
  161. [SOLVED:] LABEL AND PLANNING SCHOOL MAP (10 replies)
  162. Microsoft Calendar Control 8.0 (2 replies)
  163. [SOLVED:] VBA To convert Formula(s) to Value(s) to track serial numbers (10 replies)
  164. Creating and using an Excel VBA framework (6 replies)
  165. Find 1st cell under header, and fill down vs adjacent column (8 replies)
  166. [SOLVED:] Need help with simple syntax error (4 replies)
  167. Smart Dropdown Search (1 replies)
  168. [SOLVED:] Drop down changes value of another drop down (2 replies)
  169. [SOLVED:] Shorten code (5 replies)
  170. Button to Search Subfolders for files (26 replies)
  171. Set fs = Application.FileSearch within 2003 Macro no longer valid? (3 replies)
  172. Financial Functions (1 replies)
  173. [SOLVED:] Help me with syntax of the code...anyone? (4 replies)
  174. [SOLVED:] Active X "Missing" error when others attempt to use file (7 replies)
  175. [SOLVED:] Click on Cell, Pop-up with input, put answers into a cell (1 replies)
  176. Whats the best way to delete the lines i just copied and pasted over (code inside) (3 replies)
  177. Put Data From Excel 2010 Into Web Page Field (1 replies)
  178. Help with Error Handling (10 replies)
  179. extract numbers (10 replies)
  180. Add items from Comboxes to Listbox (8 replies)
  181. [SOLVED:] Array with month (10 replies)
  182. Accessing Web Service From Excel 2013 with Input Parameters (9 replies)
  183. Excel VBA Help: Checking String Values of Two Columns for Equality (2 replies)
  184. Coping with duplicates being created by code splitting worksheets into separate files (17 replies)
  185. Help With Mac VBA script SaveAs (0 replies)
  186. [SOLVED:] Excel to Email with Attachment, based on different names & then folders (1 replies)
  187. [SOLVED:] Problem with split (2 replies)
  188. [SOLVED:] Having a date take effect at a specific time of day (1 replies)
  189. From word file names to excel database (15 replies)
  190. [SOLVED:] Split names with no space: (8 replies)
  191. Problem linking two sheets (3 replies)
  192. [SOLVED:] Macro to highlight certain cells highlighting too much (4 replies)
  193. split alt+enter values of a cells into multiple cells (3 replies)
  194. Arrays 101 (6 replies)
  195. [SOLVED:] Loop macro - copy, paste, run macro (1 replies)
  196. [SOLVED:] SPINBUTTON RIGHT TO LEFT (10 replies)
  197. [SOLVED:] With...With end condition not working referencing a range (2 replies)
  198. Any add-In available that can convert my excel sheet and word file to pdf (2 replies)
  199. VBA for entering data into a webpage from excel 2010 (1 replies)
  200. [SOLVED:] Automatically Hyperlink Text in a Cell, based on another Cell (5 replies)
  201. Launch Website and log in (0 replies)
  202. Adapt code to move files to a subfolder of the same name (3 replies)
  203. Copy/Insert union of subranges into existing worksheet (4 replies)
  204. Can someone help on my code enhancement (6 replies)
  205. Show Installed Digital Certificates programatically using a Macro (0 replies)
  206. Help with userform (1 replies)
  207. Excel Macro Procedure Too Large Error - Help (3 replies)
  208. Improving Macro (1 replies)
  209. Importing a Portion of a .txt file by pattern - Please Help (14 replies)
  210. [SOLVED:] Macro to make userform appear when clicked anywhere in Column D (4 replies)
  211. [SOLVED:] Advancing cell referencing each month (41 replies)
  212. [SOLVED:] Optimize Macro (8 replies)
  213. [SOLVED:] AutoBackup / Make 1 extra copy of my workbook (10 replies)
  214. Intersecting range and array (3 replies)
  215. Anyone can help? (1 replies)
  216. How to write myConnection(id) (0 replies)
  217. Display outlook mail from VBA (1 replies)
  218. [SOLVED:] Need help to autofil with VBA (3 replies)
  219. VBA "Error loading DLL" wrong PowerPoint reference (Excel 2010) (0 replies)
  220. Copying and pasting a dynamic range (3 replies)
  221. Input From TextBox to Web Site (3 replies)
  222. [SLEEPER:] How to get the data back from website to excel (0 replies)
  223. code to copy content to adjacent cells based on a cell value (1 replies)
  224. Generate Outlook E-mail via Word using VBA, Formatting Issue (0 replies)
  225. ShowWindowsInTaskbar in 2010 (1 replies)
  226. [SOLVED:] Autofill certain cells with VBA (0 replies)
  227. [SOLVED:] in cell forumla (3 replies)
  228. MY LAST USF BY VLOOKUP VBA (4 replies)
  229. Refresh Spreadsheet data and Pop-up message based on critera (9 replies)
  230. [SOLVED:] Need to loop until last cell need to modify (1 replies)
  231. [SOLVED:] Match two different columns (4 replies)
  232. [SOLVED:] sick record (6 replies)
  233. Email With attachments, Changeable users (9 replies)
  234. Create multiple Free text Search Tabs in Excel (1 replies)
  235. VBA to Concatenate Multi-Value Cells (12 replies)
  236. [SOLVED:] handling .txt files with 4mio lines (610 mb)! (7 replies)
  237. Select a Range based in a criteria, copy to a new workbook and attach in Outlook (1 replies)
  238. [SOLVED:] Compare two cell in two columns and present in new column (4 replies)
  239. EXCEL/VBA macro for print address wrong spreadsheet in wrong workbook (4 replies)
  240. [SOLVED:] Need help to copy the UsedRange (5 replies)
  241. [SOLVED:] need help with regex (5 replies)
  242. [SLEEPER:] How to disable Heading Control, via VBA in the Ribbon, View Tab (1 replies)
  243. Saving File Gives Error Excel VBA (6 replies)
  244. [SOLVED:] Help with Error Message returning the Row and Sheet that contains the error (3 replies)
  245. [SOLVED:] Data validation - Team Name, Thread and Sub-Thread (3 replies)
  246. Directory Issue (9 replies)
  247. [SOLVED:] Detecting Change in Value (3 replies)
  248. Fill A AZ (14 replies)
  249. [SOLVED:] Add a row with more than 10 columns to a ListBox? (24 replies)
  250. [SOLVED:] Value to stay visible (9 replies)