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 174

  1. [SLEEPER:] VBA code to rename folders (3 replies)
  2. [SOLVED:] Copy first 5 characters of Course Name to Column A (3 replies)
  3. [SOLVED:] Individually generate email content and attached all files from folder based on cell (3 replies)
  4. Sort All Sheets In Workbook (12 replies)
  5. Code guidance please (9 replies)
  6. [SOLVED:] Need VBA code for Copy+insert / Delete rows & columns by criteria (4 replies)
  7. Gantt Chart (3 replies)
  8. Looking for help with VBA code please? (10 replies)
  9. [SOLVED:] Problems using ComboBox (1 replies)
  10. VBA Simple Code Help (Formatting FDM) (9 replies)
  11. Multi-choice of the listbox to many controls(textbox) (4 replies)
  12. From Sheet.add to Workbook add method (7 replies)
  13. Copy and rename files without overwriting files (1 replies)
  14. [SOLVED:] Help to create a date range chart based on a date wthin the data (16 replies)
  15. Error 53 "file not found" (3 replies)
  16. All VBA Code Stopped Working (1 replies)
  17. Extract data from LinkedIn (2 replies)
  18. Save Worksheet as PDF and Attach in Outlook (9 replies)
  19. VBA: Apply loop to existing code (6 replies)
  20. VBA code to Copy/Insert + Delete rows by criteria (2 replies)
  21. Can't select and activate cells during BeforePrint event (8 replies)
  22. How to login with vba (6 replies)
  23. Problems Initiating a User Defined Function UDF - Using Application.caller.row (4 replies)
  24. Sleeper: VBA to group matching data and copy for printing (0 replies)
  25. Macro: Sheet 1 populates Sheets 2 & 3 with unique records only. (stuck) (3 replies)
  26. Excel VBA Database (5 replies)
  27. Meaning of iLastColumn = .Column + .MergeArea.Columns.Count - 1 (2 replies)
  28. Pasting excel tables one after the other from excel into a word document (0 replies)
  29. VBA Multiple Attachments (4 replies)
  30. VBA an MSGBOX (4 replies)
  31. ie.navigate to follow links from A1 to A2000 (12 replies)
  32. [SOLVED:] INDIRECT Row Reference and Increments (7 replies)
  33. [SOLVED:] Help with VBA password in commanduttons (3 replies)
  34. Saving to different folders based on part numbers in B1 (2 replies)
  35. Download from FTP (6 replies)
  36. [SOLVED:] Initialize modeless FYI Userform but focus never leaves sheet (9 replies)
  37. Copying multiple ranges to Word (0 replies)
  38. Find duplicates with VBA (2 replies)
  39. [SLEEPER:] Exit User Form Button (4 replies)
  40. add payment button vba code (1 replies)
  41. Insert row automatically? (17 replies)
  42. Insert Excel cell range in Shell command (8 replies)
  43. loop, vba (10 replies)
  44. When Limit has reached in Excel, send to Sheet2 (3 replies)
  45. Use WinHttpRequest#responseStream for SOAP Request (1 replies)
  46. Question about create Macro manage information. (2 replies)
  47. Issues about source in excel 2010. (2 replies)
  48. VBA Coding to send a common email to different email addresses based on cell values (1 replies)
  49. [SOLVED:] CheckBox on UserForm to show Full list or Part list according to Criteria (6 replies)
  50. Sleeper: Open Hyperlink File From Cell - Follow Hyperlink (9 replies)
  51. Adapt macro that copies excel to ppt (3 replies)
  52. Macro to count repeat occurrences from closed WB and paste total counts in new WB (7 replies)
  53. Macro for executing commands from cmd prompt (3 replies)
  54. Need help of members with spreadsheet allows users to manipulate. (1 replies)
  55. Questions about conditions in excel function. (3 replies)
  56. Open all pdf one by one from a folder using followhyperlink (0 replies)
  57. Search for postcodes in a PDF document and list them in a excel worksheet (5 replies)
  58. [SOLVED:] Please Help me (10 replies)
  59. Autofill Across Columns with "Centered Across Formatted (3 Columns)" Quarterly Dates (10 replies)
  60. Search List, Find Sheet, Return Value (6 replies)
  61. Out of Memory error on close tries to open protected VBA (7 replies)
  62. Chart - Plot has different size (1 replies)
  63. Problem about a variable value In excel. (2 replies)
  64. Information about Transferring Data In Excel. (3 replies)
  65. Run time error 429 - ActiveX component can't create object. (5 replies)
  66. Delete Entire Row Based on a Selection (5 replies)
  67. Match to master (5 replies)
  68. [SOLVED:] Automatically Update TextBox on Other Sheet (6 replies)
  69. Copying cells from worksheet that varies in cell range and number of pages. (1 replies)
  70. Delete all AllowEditRanges in workbook (1 replies)
  71. SAVEAS with location (1 replies)
  72. How select next blank cell in row and add timestap (2 replies)
  73. How To Copy excel to powerpoint (0 replies)
  74. Problem about function reference (1 replies)
  75. [SOLVED:] How to Combine a Save As PDF macro and an E-Mail send macro??? (6 replies)
  76. Help adding font size / color / etc to my macro (2 replies)
  77. Cycling through sheets with loop (8 replies)
  78. Hyperlink With Special Characters (1 replies)
  79. convert column to matrix (1 replies)
  80. [SOLVED:] For If Statement with Two Ranges (2 replies)
  81. Can I "cancel" Workbook_WindowDeactivate? (0 replies)
  82. Amending Code To Reference value (Email address) In Cell (1 replies)
  83. Search data in 4 Contiguous cells within a selected area (4 replies)
  84. How To Copy just the value in Excel. (1 replies)
  85. operations copy and paste file from Adobe Reader (0 replies)
  86. [SOLVED:] Loop through sheets based on cell contents (2 replies)
  87. Sum with weeknumbers of a given date (0 replies)
  88. [SOLVED:] Show/Hide a Textbox Based on Value of a Combo Box in a USerform (3 replies)
  89. Email Range Of Cells (1 replies)
  90. [SOLVED:] Auto Save Excel File as PDF (5 replies)
  91. Outlook Calendar In Excel (2 replies)
  92. Checking For Commands From Central Server (0 replies)
  93. [SOLVED:] Hide Column Target Cell Clicked - From a List (2 replies)
  94. Logit VBA Debugging (4 replies)
  95. Problem about Loop through files sort by Date. (1 replies)
  96. Problem about sort horizontal with Function. (1 replies)
  97. Put linear trendline equation into cell (6 replies)
  98. VBA Help (4 replies)
  99. [SOLVED:] LastRow from a specific Cell (5 replies)
  100. Convert to For Next loop (1 replies)
  101. Macro to concatenate cells into a single cell multiple times (2 replies)
  102. [SOLVED:] Help with Dynamic UserForm in Excel (5 replies)
  103. Save Specific Protected Sheets to a new Workbook (0 replies)
  104. [SOLVED:] How can I run VBA Worksheet_BeforeDoubleClick on a (new) daily extract.csv (17 replies)
  105. [SOLVED:] Issue with AVERAGEIF (6 replies)
  106. Is a Multi-Cell Row Power Search Possible? (1 replies)
  107. Embedded image in Gmail only works with .Display before .Send (0 replies)
  108. Problem about data form excel to API (1 replies)
  109. How To Create a spreadsheet in excel (2 replies)
  110. [SOLVED:] How to Save listbox items to .csv file (12 replies)
  111. Need help constructing a vba to remove duplicates and its original and spare the uniq (14 replies)
  112. [SOLVED:] Pass Sheet Codename as argument to Subroutine (4 replies)
  113. Need one Sub for all CheckBoxes. (13 replies)
  114. [SOLVED:] If only blanks PIVOT should not be inserted (21 replies)
  115. [SLEEPER:] VBA Exam type of questions (3 replies)
  116. [SOLVED:] Convert Text body in email to HTML (2 replies)
  117. Help with using a UDF as the criteria for a countif formula (1 replies)
  118. [SOLVED:] Protected View, Enable Edit causes Runtime Error 91 or 1004 (4 replies)
  119. [SOLVED:] Assigning datalabels to doughnut charts with vba (9 replies)
  120. how to export the data into .excel in VBA (1 replies)
  121. Date Automation (2 replies)
  122. [SOLVED:] VBA To Hide or Show Rows (9 replies)
  123. Autosum current column in a table (6 replies)
  124. Assign value to shape by double clicking (1 replies)
  125. [SOLVED:] Fill an array LIKE a multiplication table with a macro (4 replies)
  126. Copy specific links into excel from explorer html (0 replies)
  127. [SLEEPER:] Paytm Automation help (0 replies)
  128. [SLEEPER:] Group Columns are not expanded (1 replies)
  129. Gmail search box automation - Need Help (0 replies)
  130. Create PDF of Workbook or Individual sheets by last used row & column and send email (9 replies)
  131. From Template file Force Save and Close (0 replies)
  132. [SOLVED:] Catching error messages (1 replies)
  133. VBA code for if else based on date (9 replies)
  134. Transpose Column to Row (2 column) (2 replies)
  135. Transpose column by date( Excel or VBA) (1 replies)
  136. Do until loop in Excel (3 replies)
  137. [SOLVED:] How to prevent a Pivot Table from Re-Sizing (3 replies)
  138. [SOLVED:] Add missing text in certain cells (5 replies)
  139. when run macro, original file auto open (0 replies)
  140. How to amend a formula to a new criteria (3 replies)
  141. Calendar Control Not Working using VBA Code (4 replies)
  142. Help wanted.... (0 replies)
  143. [SOLVED:] Auto E-Mail an Excel File When Saved??? (5 replies)
  144. [SOLVED:] Filter and name the rows when available (4 replies)
  145. Copying of one Cell Value each Row as excel runs down the Page. (12 replies)
  146. Outlook to Excel Table using VBA having a small issue (1 replies)
  147. [SOLVED:] Pivot field moments Postion{1,5}. in case if the items availabe (7 replies)
  148. [SOLVED:] Macro works only in one workbook (2 replies)
  149. Userform: How do I disallow "save & exit" if requried fields are not filled-in? (4 replies)
  150. Import/Extract Information from Word to Excel using VBA (12 replies)
  151. [SLEEPER:] Help with LinkedIn (3 replies)
  152. [SOLVED:] Need Macro To Change And Add So Many Days To A Cell With A Date (3 replies)
  153. VBA to look for certain parameters in a word and populate a single data to excel (1 replies)
  154. [SOLVED:] Two-column data transferred to single cell (4 replies)
  155. Macro to save spreedsheet as new file (12 replies)
  156. [SOLVED:] Sequence Function (1 replies)
  157. [SOLVED:] Getting Attachments from Outlook with Excel VBA (4 replies)
  158. Match cells from another workbook & then copy (2 replies)
  159. Extracting Word Table cell Information from Multiple .docx Files on an Intranet page (1 replies)
  160. Two Combo Boxes Active Control in the same sheet affecting each other (12 replies)
  161. [SOLVED:] Formula/VBA help (3 replies)
  162. VBA Code Indentation tool for x86 and x64 Excel (1 replies)
  163. How to close excel properly (3 replies)
  164. [SOLVED:] Copy color from range of cells (3 replies)
  165. How to remove duplicates within duplication sets based on criteria? (11 replies)
  166. Automation of email classification selection (9 replies)
  167. Filter and create outlook email (1 replies)
  168. Make the range dynamic (4 replies)
  169. [SOLVED:] VBA or Formula? to assign a number based on driving miles (15 replies)
  170. Add Usedrange property in the existing code (5 replies)
  171. [SOLVED:] Merging workbooks (8 replies)
  172. VBA Code/Macro Help (5 replies)
  173. Identify Font used in XLS sheet (6 replies)
  174. VBA Copy An Paste Only Copying 1st Row (7 replies)
  175. How to match index with two criterias and multiple dates? (11 replies)
  176. Macro to identify selected point in Excel chart (0 replies)
  177. Excel 2010 formula reccomendations (0 replies)
  178. VBA Copy/Paste Data Based Off ActiveX Dropdown Box (2 replies)
  179. [SOLVED:] Folders path in excel cell (10 replies)
  180. Help Creating a Custom Desktop Shortcut (0 replies)
  181. help building formula string (2 replies)
  182. [SOLVED:] Linking macro in one sheet to anothwer sheet (3 replies)
  183. [SOLVED:] Error with Find (438) (2 replies)
  184. [SOLVED:] Set powerpoint presentation opened from excel as active (2 replies)
  185. Transfer Selected Body Content from Outlook to Excel (1 replies)
  186. Advice needed (2 replies)
  187. [SOLVED:] Sending email with links disabled in sheets (11 replies)
  188. [SOLVED:] Transpose rows to columns (3 replies)
  189. [SOLVED:] Create a Copy of workbook with selected sheets (5 replies)
  190. [SOLVED:] Import Text Content From File - Stored in SubFolders - If It Matches File Name Col A (4 replies)
  191. How to express my cell range dynamically (using numbers) in VBA? (6 replies)
  192. [SOLVED:] VBA Clear contents help (3 replies)
  193. Average Function-Cannot do Copy and Drag with Quarterly Avg. Calc - Periodicity Issue (5 replies)
  194. [SOLVED:] Table editing (12 replies)
  195. [SOLVED:] Multiple lookups for string in once cell and return comma separated values (6 replies)
  196. VBA Deleting rows from specific cells based on some condition (31 replies)
  197. VBA to Delete Leading ,Trailing and Excess Spaces in Excel (2 replies)
  198. How to access Onedrive folder using macro / VBA? (0 replies)
  199. [SOLVED:] How to check if Cells has content or not (3 replies)
  200. [SOLVED:] VBA CellMovement from ActiveCell (3 replies)
  201. Help with vba (11 replies)
  202. [SOLVED:] Dynamic Table Array for Pivot Table in VBA (7 replies)
  203. Userform to Image (2 replies)
  204. VBA Loop Through Columns (8 replies)
  205. Excel VBA Queries (2 replies)
  206. How to save PP as pptx instead of ppt from Excel VBA (1 replies)
  207. VBA code to build Pivot tables in “Existing sheets”. (11 replies)
  208. [SOLVED:] [VBA] Copying cells from one sheet to another (6 replies)
  209. Return All Matching Rows On Button Press (1 replies)
  210. Sleeper: Scan barcode to two documents at the same time (0 replies)
  211. advanced filter code - subscript out of range/'Name' of object '_Worksheet' failed (3 replies)
  212. [ Excel ] drop down list with fixed area of dynamic table for user to enter data (4 replies)
  213. Breaking Powerpoint slidemaster link from Excel vba + quick macro question (6 replies)
  214. [SOLVED:] Align Row Content with cell format to Left column & Delete Blank row (12 replies)
  215. Export excel to pdf with pass (5 replies)
  216. ActiveX controls in office 2016 distort when design mode is off (1 replies)
  217. VBA Code will not search subfolders. (4 replies)
  218. Help with compare code (5 replies)
  219. Help Posting?? (9 replies)
  220. [SOLVED:] Finding Last Column with CF Format - Paste Previous 6 columns format to Empty Column (16 replies)
  221. [SOLVED:] Import from a Number of Worksheets Listed in a Column (3 replies)
  222. vba excel macro data between two dates (9 replies)
  223. Excel to Outlook Bold Text & Include Auto Signature (3 replies)
  224. [SOLVED:] Need help restucturing VBA Macro please! (6 replies)
  225. Multiple Modes (1 replies)
  226. [SOLVED:] Need Help: Replace all Cells of a Column with its Caption, if Cells Value is "TRUE" (5 replies)
  227. [SOLVED:] Need help const a VBA Macro to record 3rd and 4th digits, place in to rght in col B (7 replies)
  228. [SOLVED:] Extracting Form Fields from Word to Excel run-time error (2 replies)
  229. Need to VBA Grouping for 2500 Rows. (8 replies)
  230. Code Randomly works - No Pattern to when it does not work. Help Please (11 replies)
  231. spread repated cells (4 replies)
  232. [SOLVED:] Excel program & left in the lurch--please help (5 replies)
  233. [SOLVED:] Stripping Line Breaks (10 replies)
  234. Help with merging workbooks (2 replies)
  235. [SOLVED:] Scrolling not working for TreeView (8 replies)
  236. [SOLVED:] AVERAGEIF Specific cells ignoring #DIV/0! (12 replies)
  237. Loop through all worksheets in chosen folder to remove duplicate rows (10 replies)
  238. Integrate multiple filesd in a specific directory to one worksheet in a separate file (1 replies)
  239. Macro to Deduct and Display Time in Userform TextBox (2 replies)
  240. [SOLVED:] VBA Coding for Averageifs that needs to dynamically adjust over 8 quarters (6 replies)
  241. Help with Count if (5 replies)
  242. Copy down formula then remove formula from where it copied with paste it as value (6 replies)
  243. listobox remove item erorr (2 replies)
  244. [SOLVED:] Copying & Pasting Values on Same Sheet to New Table - Pasting Issues... (8 replies)
  245. VBA to Retrieve Information from Multiple Workbooks (0 replies)
  246. query close problem (1 replies)
  247. [SOLVED:] Multiple Lookup Criteria - Help Required (4 replies)
  248. [SOLVED:] Transposing each set of 22 items (all from the same column) into rows (11 replies)
  249. Help Converting Early Binding to Late Binding VBA Code (5 replies)
  250. Refine code to combine multiple CSV files into single workbook (7 replies)