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. Adding Code to Workbook_BeforeOpen (7 replies)
  2. [SOLVED:] Find a Value in a Cell and Delete some of the text (2 replies)
  3. Concat date and time in one cell (1 replies)
  4. Open workbook with dynamic filename (8 replies)
  5. [SOLVED:] Conditional Compile Question (11 replies)
  6. [SOLVED:] Forms 2.0 library (9 replies)
  7. VBA code disaappeared. (4 replies)
  8. "MSACCESS.EXE" process issue - How to terminate this process correctly (2 replies)
  9. [SOLVED:] Find Text Within A String (4 replies)
  10. [SOLVED:] Find and replace (9 replies)
  11. Group Shapes Rename Them - Loop Through Worksheets (1 replies)
  12. [SOLVED:] VBA to create a mapping (0 replies)
  13. Need help with this macro to have it work with Alpha Numeric data (2 replies)
  14. [SOLVED:] Assign Shape Macros - From List (2 replies)
  15. Data Formating - Macro to copy header row and paste to multiple columns. (1 replies)
  16. Help me insert subtotals on I:L my vba code below. It sorts and insets a blank row (0 replies)
  17. Run-time error '462': The remote server machine does not exist or is unavailable (0 replies)
  18. Ping tester in Excal (2 replies)
  19. SUMPRODUCT in VBA (7 replies)
  20. [SOLVED:] Add shape only if shape doesn't already exist (1 replies)
  21. [SOLVED:] Remove Apostrophe from string (4 replies)
  22. [SOLVED:] Macro to create list of hyperlinks to all files in chosen folder including subfolders (8 replies)
  23. [SOLVED:] On Open: "This action will reset your project, proceed anyway?" (26 replies)
  24. [SOLVED:] Trouble using selected range to define a for loop (3 replies)
  25. [SOLVED:] Unhide Worksheet on Selection of Cell (2 replies)
  26. [SOLVED:] Code to match to cells using a mapping (3 replies)
  27. Delete rows except the last one with same numerical value (1 replies)
  28. Codigo VBA para fecha matar o arquivo temporário. (0 replies)
  29. Can VBA be used to search a folder of .docx's for text strings and copypaste to Excel (1 replies)
  30. [SOLVED:] Left Right Function Help (4 replies)
  31. Google map Travel Planner #1 (0 replies)
  32. [SOLVED:] Match and Vlookup method (3 replies)
  33. [SOLVED:] Run-time error 91 (4 replies)
  34. Trying to extract all data from word docs into excel docs (0 replies)
  35. VBA Express Certification? (0 replies)
  36. [SOLVED:] Identify column header name based on a colored cell (6 replies)
  37. Copy data from one sheet to another based on a certain criteria (1 replies)
  38. [SOLVED:] How to get Last Digit from Text (3 replies)
  39. How to conjuct all the excel value into one cell? (1 replies)
  40. Convert Vlookup to VBA (22 replies)
  41. Hyperlink Issue (2 replies)
  42. Resetting Dropdown list in all sheets (Excel Workbook) (0 replies)
  43. [SOLVED:] How to check whether Cells contains specific number? (3 replies)
  44. Stopping or breaking userform or code causes VBA to flip through all userforms (0 replies)
  45. Match two rows across various columns using VBA (2 replies)
  46. Hitro Macors (3 replies)
  47. Generate random values between two number and specific string (1 replies)
  48. VB script to filter and update value in different sheet (2 replies)
  49. Embed an "open file" dialogue box to userform, Excel 64 bit version (5 replies)
  50. Copy line by index number and past in another worksheet (0 replies)
  51. Copy select data to different column (1 replies)
  52. Stock Length Calculator (0 replies)
  53. [SOLVED:] Require VBA Macro logic for Multiple ID and Matching Columns data. (9 replies)
  54. [SOLVED:] Match two rows using VBA (1 replies)
  55. [SOLVED:] UDF to convert column Letter to Number and return the Largest column as Number (4 replies)
  56. Macro to conditionally insert rows not functioning as intended (1 replies)
  57. [SOLVED:] Send attachment via outlook (2 replies)
  58. [SOLVED:] Combo box filtering? (3 replies)
  59. Copy select data on USERFORM (1 replies)
  60. Why data labels gone when i paste the chart to other workbook and change the range? (0 replies)
  61. Validation Tool- Lookup for Mis-Match and send email out (0 replies)
  62. Need help with a VBA code for distributing data (3 replies)
  63. Workbook Password Protect (10 replies)
  64. Open Images Folder Mac OSX (0 replies)
  65. [SOLVED:] Hide rows between 2 strings (3 replies)
  66. [SOLVED:] Fix calculation of minimum date (1 replies)
  67. Pivot > Showall data in rows field (1 replies)
  68. Excel File-1 copy the value & compare with Excel File-2 and Save it in Excel File-1 ? (0 replies)
  69. VBA Command button (20 replies)
  70. Need VBA Code to close userform (6 replies)
  71. Sleeper: Help with combining these macro snippets? (3 replies)
  72. [SOLVED:] Using Workbook from FilePicker (4 replies)
  73. Loop through Vlookup (4 replies)
  74. Auto-resize Shape_width (1 replies)
  75. Passing Data from UserForm to Sheet makes excel to crash (Why?) (4 replies)
  76. HTML click not consistently working (0 replies)
  77. VBA Checkbox buttons (4 replies)
  78. [SLEEPER:] Populating checked items in worksheet1 to worksheet2 (0 replies)
  79. [SOLVED:] Sorting Sheets in a specific order (2 replies)
  80. Copy Missing Data to Main Worksheet. (4 replies)
  81. Sleeper: Copy Paste as Values & Save as new sheet (1 replies)
  82. [SOLVED:] Set Variable of column number to Multicolumn ListBox (2 replies)
  83. Unable to read last line from VBA plink stdout (11 replies)
  84. VBA code to rename folders (3 replies)
  85. [SOLVED:] Copy first 5 characters of Course Name to Column A (3 replies)
  86. [SOLVED:] Individually generate email content and attached all files from folder based on cell (3 replies)
  87. Sort All Sheets In Workbook (12 replies)
  88. Code guidance please (9 replies)
  89. [SOLVED:] Need VBA code for Copy+insert / Delete rows & columns by criteria (4 replies)
  90. Gantt Chart (3 replies)
  91. Looking for help with VBA code please? (10 replies)
  92. [SOLVED:] Problems using ComboBox (1 replies)
  93. VBA Simple Code Help (Formatting FDM) (9 replies)
  94. Multi-choice of the listbox to many controls(textbox) (4 replies)
  95. From Sheet.add to Workbook add method (7 replies)
  96. Copy and rename files without overwriting files (1 replies)
  97. [SOLVED:] Help to create a date range chart based on a date wthin the data (16 replies)
  98. Error 53 "file not found" (3 replies)
  99. All VBA Code Stopped Working (1 replies)
  100. Extract data from LinkedIn (2 replies)
  101. Save Worksheet as PDF and Attach in Outlook (9 replies)
  102. VBA: Apply loop to existing code (6 replies)
  103. VBA code to Copy/Insert + Delete rows by criteria (2 replies)
  104. Can't select and activate cells during BeforePrint event (8 replies)
  105. How to login with vba (6 replies)
  106. Problems Initiating a User Defined Function UDF - Using Application.caller.row (4 replies)
  107. Sleeper: VBA to group matching data and copy for printing (0 replies)
  108. Macro: Sheet 1 populates Sheets 2 & 3 with unique records only. (stuck) (3 replies)
  109. Excel VBA Database (5 replies)
  110. Meaning of iLastColumn = .Column + .MergeArea.Columns.Count - 1 (2 replies)
  111. Pasting excel tables one after the other from excel into a word document (0 replies)
  112. VBA Multiple Attachments (4 replies)
  113. VBA an MSGBOX (4 replies)
  114. ie.navigate to follow links from A1 to A2000 (12 replies)
  115. [SOLVED:] INDIRECT Row Reference and Increments (7 replies)
  116. [SOLVED:] Help with VBA password in commanduttons (3 replies)
  117. Saving to different folders based on part numbers in B1 (2 replies)
  118. Download from FTP (6 replies)
  119. [SOLVED:] Initialize modeless FYI Userform but focus never leaves sheet (9 replies)
  120. Copying multiple ranges to Word (0 replies)
  121. Find duplicates with VBA (2 replies)
  122. Exit User Form Button (4 replies)
  123. add payment button vba code (1 replies)
  124. Insert row automatically? (17 replies)
  125. Insert Excel cell range in Shell command (8 replies)
  126. loop, vba (10 replies)
  127. When Limit has reached in Excel, send to Sheet2 (3 replies)
  128. Use WinHttpRequest#responseStream for SOAP Request (1 replies)
  129. Question about create Macro manage information. (2 replies)
  130. Issues about source in excel 2010. (2 replies)
  131. VBA Coding to send a common email to different email addresses based on cell values (1 replies)
  132. [SOLVED:] CheckBox on UserForm to show Full list or Part list according to Criteria (6 replies)
  133. Sleeper: Open Hyperlink File From Cell - Follow Hyperlink (9 replies)
  134. Adapt macro that copies excel to ppt (3 replies)
  135. Macro to count repeat occurrences from closed WB and paste total counts in new WB (7 replies)
  136. Macro for executing commands from cmd prompt (3 replies)
  137. Need help of members with spreadsheet allows users to manipulate. (1 replies)
  138. Questions about conditions in excel function. (3 replies)
  139. Open all pdf one by one from a folder using followhyperlink (0 replies)
  140. Search for postcodes in a PDF document and list them in a excel worksheet (5 replies)
  141. [SOLVED:] Please Help me (10 replies)
  142. Autofill Across Columns with "Centered Across Formatted (3 Columns)" Quarterly Dates (10 replies)
  143. Search List, Find Sheet, Return Value (6 replies)
  144. Out of Memory error on close tries to open protected VBA (7 replies)
  145. Chart - Plot has different size (1 replies)
  146. Problem about a variable value In excel. (2 replies)
  147. Information about Transferring Data In Excel. (3 replies)
  148. Run time error 429 - ActiveX component can't create object. (5 replies)
  149. Delete Entire Row Based on a Selection (5 replies)
  150. Match to master (5 replies)
  151. [SOLVED:] Automatically Update TextBox on Other Sheet (6 replies)
  152. Copying cells from worksheet that varies in cell range and number of pages. (1 replies)
  153. Delete all AllowEditRanges in workbook (1 replies)
  154. SAVEAS with location (1 replies)
  155. How select next blank cell in row and add timestap (2 replies)
  156. How To Copy excel to powerpoint (0 replies)
  157. Problem about function reference (1 replies)
  158. [SOLVED:] How to Combine a Save As PDF macro and an E-Mail send macro??? (6 replies)
  159. Help adding font size / color / etc to my macro (2 replies)
  160. Cycling through sheets with loop (8 replies)
  161. Hyperlink With Special Characters (1 replies)
  162. convert column to matrix (1 replies)
  163. [SOLVED:] For If Statement with Two Ranges (2 replies)
  164. Can I "cancel" Workbook_WindowDeactivate? (0 replies)
  165. Amending Code To Reference value (Email address) In Cell (1 replies)
  166. Search data in 4 Contiguous cells within a selected area (4 replies)
  167. How To Copy just the value in Excel. (1 replies)
  168. operations copy and paste file from Adobe Reader (0 replies)
  169. [SOLVED:] Loop through sheets based on cell contents (2 replies)
  170. Sum with weeknumbers of a given date (0 replies)
  171. [SOLVED:] Show/Hide a Textbox Based on Value of a Combo Box in a USerform (3 replies)
  172. Email Range Of Cells (1 replies)
  173. [SOLVED:] Auto Save Excel File as PDF (5 replies)
  174. Outlook Calendar In Excel (2 replies)
  175. Checking For Commands From Central Server (0 replies)
  176. [SOLVED:] Hide Column Target Cell Clicked - From a List (2 replies)
  177. Logit VBA Debugging (4 replies)
  178. Problem about Loop through files sort by Date. (1 replies)
  179. Problem about sort horizontal with Function. (1 replies)
  180. Put linear trendline equation into cell (6 replies)
  181. VBA Help (4 replies)
  182. [SOLVED:] LastRow from a specific Cell (5 replies)
  183. Convert to For Next loop (1 replies)
  184. Macro to concatenate cells into a single cell multiple times (2 replies)
  185. [SOLVED:] Help with Dynamic UserForm in Excel (5 replies)
  186. Save Specific Protected Sheets to a new Workbook (0 replies)
  187. [SOLVED:] How can I run VBA Worksheet_BeforeDoubleClick on a (new) daily extract.csv (17 replies)
  188. [SOLVED:] Issue with AVERAGEIF (6 replies)
  189. Is a Multi-Cell Row Power Search Possible? (1 replies)
  190. Embedded image in Gmail only works with .Display before .Send (0 replies)
  191. Problem about data form excel to API (1 replies)
  192. How To Create a spreadsheet in excel (2 replies)
  193. [SOLVED:] How to Save listbox items to .csv file (12 replies)
  194. Need help constructing a vba to remove duplicates and its original and spare the uniq (14 replies)
  195. [SOLVED:] Pass Sheet Codename as argument to Subroutine (4 replies)
  196. Need one Sub for all CheckBoxes. (13 replies)
  197. [SOLVED:] If only blanks PIVOT should not be inserted (21 replies)
  198. [SLEEPER:] VBA Exam type of questions (3 replies)
  199. [SOLVED:] Convert Text body in email to HTML (2 replies)
  200. Help with using a UDF as the criteria for a countif formula (1 replies)
  201. [SOLVED:] Protected View, Enable Edit causes Runtime Error 91 or 1004 (4 replies)
  202. [SOLVED:] Assigning datalabels to doughnut charts with vba (9 replies)
  203. how to export the data into .excel in VBA (1 replies)
  204. Date Automation (2 replies)
  205. [SOLVED:] VBA To Hide or Show Rows (9 replies)
  206. Autosum current column in a table (6 replies)
  207. Assign value to shape by double clicking (1 replies)
  208. [SOLVED:] Fill an array LIKE a multiplication table with a macro (4 replies)
  209. Copy specific links into excel from explorer html (0 replies)
  210. Paytm Automation help (0 replies)
  211. Group Columns are not expanded (1 replies)
  212. Gmail search box automation - Need Help (0 replies)
  213. Create PDF of Workbook or Individual sheets by last used row & column and send email (9 replies)
  214. From Template file Force Save and Close (0 replies)
  215. [SOLVED:] Catching error messages (1 replies)
  216. VBA code for if else based on date (9 replies)
  217. Transpose Column to Row (2 column) (2 replies)
  218. Transpose column by date( Excel or VBA) (1 replies)
  219. Do until loop in Excel (3 replies)
  220. [SOLVED:] How to prevent a Pivot Table from Re-Sizing (3 replies)
  221. [SOLVED:] Add missing text in certain cells (5 replies)
  222. when run macro, original file auto open (0 replies)
  223. How to amend a formula to a new criteria (3 replies)
  224. Calendar Control Not Working using VBA Code (4 replies)
  225. Help wanted.... (0 replies)
  226. [SOLVED:] Auto E-Mail an Excel File When Saved??? (5 replies)
  227. [SOLVED:] Filter and name the rows when available (4 replies)
  228. Copying of one Cell Value each Row as excel runs down the Page. (12 replies)
  229. Outlook to Excel Table using VBA having a small issue (1 replies)
  230. [SOLVED:] Pivot field moments Postion{1,5}. in case if the items availabe (7 replies)
  231. [SOLVED:] Macro works only in one workbook (2 replies)
  232. Userform: How do I disallow "save & exit" if requried fields are not filled-in? (4 replies)
  233. Import/Extract Information from Word to Excel using VBA (12 replies)
  234. [SLEEPER:] Help with LinkedIn (3 replies)
  235. [SOLVED:] Need Macro To Change And Add So Many Days To A Cell With A Date (3 replies)
  236. VBA to look for certain parameters in a word and populate a single data to excel (1 replies)
  237. [SOLVED:] Two-column data transferred to single cell (4 replies)
  238. Macro to save spreedsheet as new file (12 replies)
  239. [SOLVED:] Sequence Function (1 replies)
  240. [SOLVED:] Getting Attachments from Outlook with Excel VBA (4 replies)
  241. Match cells from another workbook & then copy (2 replies)
  242. Extracting Word Table cell Information from Multiple .docx Files on an Intranet page (1 replies)
  243. Two Combo Boxes Active Control in the same sheet affecting each other (12 replies)
  244. [SOLVED:] Formula/VBA help (3 replies)
  245. VBA Code Indentation tool for x86 and x64 Excel (1 replies)
  246. How to close excel properly (3 replies)
  247. [SOLVED:] Copy color from range of cells (3 replies)
  248. How to remove duplicates within duplication sets based on criteria? (11 replies)
  249. Automation of email classification selection (9 replies)
  250. Filter and create outlook email (1 replies)