View Full Version : Excel Help
- [SLEEPER:] VBA code to rename folders (3 replies)
- [SOLVED:] Copy first 5 characters of Course Name to Column A (3 replies)
- [SOLVED:] Individually generate email content and attached all files from folder based on cell (3 replies)
- Sort All Sheets In Workbook (12 replies)
- Code guidance please (9 replies)
- [SOLVED:] Need VBA code for Copy+insert / Delete rows & columns by criteria (4 replies)
- Gantt Chart (3 replies)
- Looking for help with VBA code please? (10 replies)
- [SOLVED:] Problems using ComboBox (1 replies)
- VBA Simple Code Help (Formatting FDM) (9 replies)
- Multi-choice of the listbox to many controls(textbox) (4 replies)
- From Sheet.add to Workbook add method (7 replies)
- Copy and rename files without overwriting files (1 replies)
- [SOLVED:] Help to create a date range chart based on a date wthin the data (16 replies)
- Error 53 "file not found" (3 replies)
- All VBA Code Stopped Working (1 replies)
- Extract data from LinkedIn (2 replies)
- Save Worksheet as PDF and Attach in Outlook (9 replies)
- VBA: Apply loop to existing code (6 replies)
- VBA code to Copy/Insert + Delete rows by criteria (2 replies)
- Can't select and activate cells during BeforePrint event (8 replies)
- How to login with vba (6 replies)
- Problems Initiating a User Defined Function UDF - Using Application.caller.row (4 replies)
- Sleeper: VBA to group matching data and copy for printing (0 replies)
- Macro: Sheet 1 populates Sheets 2 & 3 with unique records only. (stuck) (3 replies)
- Excel VBA Database (5 replies)
- Meaning of iLastColumn = .Column + .MergeArea.Columns.Count - 1 (2 replies)
- Pasting excel tables one after the other from excel into a word document (0 replies)
- VBA Multiple Attachments (4 replies)
- VBA an MSGBOX (4 replies)
- ie.navigate to follow links from A1 to A2000 (12 replies)
- [SOLVED:] INDIRECT Row Reference and Increments (7 replies)
- [SOLVED:] Help with VBA password in commanduttons (3 replies)
- Saving to different folders based on part numbers in B1 (2 replies)
- Download from FTP (6 replies)
- [SOLVED:] Initialize modeless FYI Userform but focus never leaves sheet (9 replies)
- Copying multiple ranges to Word (0 replies)
- Find duplicates with VBA (2 replies)
- [SLEEPER:] Exit User Form Button (4 replies)
- add payment button vba code (1 replies)
- Insert row automatically? (17 replies)
- Insert Excel cell range in Shell command (8 replies)
- loop, vba (10 replies)
- When Limit has reached in Excel, send to Sheet2 (3 replies)
- Use WinHttpRequest#responseStream for SOAP Request (1 replies)
- Question about create Macro manage information. (2 replies)
- Issues about source in excel 2010. (2 replies)
- VBA Coding to send a common email to different email addresses based on cell values (1 replies)
- [SOLVED:] CheckBox on UserForm to show Full list or Part list according to Criteria (6 replies)
- Sleeper: Open Hyperlink File From Cell - Follow Hyperlink (9 replies)
- Adapt macro that copies excel to ppt (3 replies)
- Macro to count repeat occurrences from closed WB and paste total counts in new WB (7 replies)
- Macro for executing commands from cmd prompt (3 replies)
- Need help of members with spreadsheet allows users to manipulate. (1 replies)
- Questions about conditions in excel function. (3 replies)
- Open all pdf one by one from a folder using followhyperlink (0 replies)
- Search for postcodes in a PDF document and list them in a excel worksheet (5 replies)
- [SOLVED:] Please Help me (10 replies)
- Autofill Across Columns with "Centered Across Formatted (3 Columns)" Quarterly Dates (10 replies)
- Search List, Find Sheet, Return Value (6 replies)
- Out of Memory error on close tries to open protected VBA (7 replies)
- Chart - Plot has different size (1 replies)
- Problem about a variable value In excel. (2 replies)
- Information about Transferring Data In Excel. (3 replies)
- Run time error 429 - ActiveX component can't create object. (5 replies)
- Delete Entire Row Based on a Selection (5 replies)
- Match to master (5 replies)
- [SOLVED:] Automatically Update TextBox on Other Sheet (6 replies)
- Copying cells from worksheet that varies in cell range and number of pages. (1 replies)
- Delete all AllowEditRanges in workbook (1 replies)
- SAVEAS with location (1 replies)
- How select next blank cell in row and add timestap (2 replies)
- How To Copy excel to powerpoint (0 replies)
- Problem about function reference (1 replies)
- [SOLVED:] How to Combine a Save As PDF macro and an E-Mail send macro??? (6 replies)
- Help adding font size / color / etc to my macro (2 replies)
- Cycling through sheets with loop (8 replies)
- Hyperlink With Special Characters (1 replies)
- convert column to matrix (1 replies)
- [SOLVED:] For If Statement with Two Ranges (2 replies)
- Can I "cancel" Workbook_WindowDeactivate? (0 replies)
- Amending Code To Reference value (Email address) In Cell (1 replies)
- Search data in 4 Contiguous cells within a selected area (4 replies)
- How To Copy just the value in Excel. (1 replies)
- operations copy and paste file from Adobe Reader (0 replies)
- [SOLVED:] Loop through sheets based on cell contents (2 replies)
- Sum with weeknumbers of a given date (0 replies)
- [SOLVED:] Show/Hide a Textbox Based on Value of a Combo Box in a USerform (3 replies)
- Email Range Of Cells (1 replies)
- [SOLVED:] Auto Save Excel File as PDF (5 replies)
- Outlook Calendar In Excel (2 replies)
- Checking For Commands From Central Server (0 replies)
- [SOLVED:] Hide Column Target Cell Clicked - From a List (2 replies)
- Logit VBA Debugging (4 replies)
- Problem about Loop through files sort by Date. (1 replies)
- Problem about sort horizontal with Function. (1 replies)
- Put linear trendline equation into cell (6 replies)
- VBA Help (4 replies)
- [SOLVED:] LastRow from a specific Cell (5 replies)
- Convert to For Next loop (1 replies)
- Macro to concatenate cells into a single cell multiple times (2 replies)
- [SOLVED:] Help with Dynamic UserForm in Excel (5 replies)
- Save Specific Protected Sheets to a new Workbook (0 replies)
- [SOLVED:] How can I run VBA Worksheet_BeforeDoubleClick on a (new) daily extract.csv (17 replies)
- [SOLVED:] Issue with AVERAGEIF (6 replies)
- Is a Multi-Cell Row Power Search Possible? (1 replies)
- Embedded image in Gmail only works with .Display before .Send (0 replies)
- Problem about data form excel to API (1 replies)
- How To Create a spreadsheet in excel (2 replies)
- [SOLVED:] How to Save listbox items to .csv file (12 replies)
- Need help constructing a vba to remove duplicates and its original and spare the uniq (14 replies)
- [SOLVED:] Pass Sheet Codename as argument to Subroutine (4 replies)
- Need one Sub for all CheckBoxes. (13 replies)
- [SOLVED:] If only blanks PIVOT should not be inserted (21 replies)
- [SLEEPER:] VBA Exam type of questions (3 replies)
- [SOLVED:] Convert Text body in email to HTML (2 replies)
- Help with using a UDF as the criteria for a countif formula (1 replies)
- [SOLVED:] Protected View, Enable Edit causes Runtime Error 91 or 1004 (4 replies)
- [SOLVED:] Assigning datalabels to doughnut charts with vba (9 replies)
- how to export the data into .excel in VBA (1 replies)
- Date Automation (2 replies)
- [SOLVED:] VBA To Hide or Show Rows (9 replies)
- Autosum current column in a table (6 replies)
- Assign value to shape by double clicking (1 replies)
- [SOLVED:] Fill an array LIKE a multiplication table with a macro (4 replies)
- Copy specific links into excel from explorer html (0 replies)
- [SLEEPER:] Paytm Automation help (0 replies)
- [SLEEPER:] Group Columns are not expanded (1 replies)
- Gmail search box automation - Need Help (0 replies)
- Create PDF of Workbook or Individual sheets by last used row & column and send email (9 replies)
- From Template file Force Save and Close (0 replies)
- [SOLVED:] Catching error messages (1 replies)
- VBA code for if else based on date (9 replies)
- Transpose Column to Row (2 column) (2 replies)
- Transpose column by date( Excel or VBA) (1 replies)
- Do until loop in Excel (3 replies)
- [SOLVED:] How to prevent a Pivot Table from Re-Sizing (3 replies)
- [SOLVED:] Add missing text in certain cells (5 replies)
- when run macro, original file auto open (0 replies)
- How to amend a formula to a new criteria (3 replies)
- Calendar Control Not Working using VBA Code (4 replies)
- Help wanted.... (0 replies)
- [SOLVED:] Auto E-Mail an Excel File When Saved??? (5 replies)
- [SOLVED:] Filter and name the rows when available (4 replies)
- Copying of one Cell Value each Row as excel runs down the Page. (12 replies)
- Outlook to Excel Table using VBA having a small issue (1 replies)
- [SOLVED:] Pivot field moments Postion{1,5}. in case if the items availabe (7 replies)
- [SOLVED:] Macro works only in one workbook (2 replies)
- Userform: How do I disallow "save & exit" if requried fields are not filled-in? (4 replies)
- Import/Extract Information from Word to Excel using VBA (12 replies)
- [SLEEPER:] Help with LinkedIn (3 replies)
- [SOLVED:] Need Macro To Change And Add So Many Days To A Cell With A Date (3 replies)
- VBA to look for certain parameters in a word and populate a single data to excel (1 replies)
- [SOLVED:] Two-column data transferred to single cell (4 replies)
- Macro to save spreedsheet as new file (12 replies)
- [SOLVED:] Sequence Function (1 replies)
- [SOLVED:] Getting Attachments from Outlook with Excel VBA (4 replies)
- Match cells from another workbook & then copy (2 replies)
- Extracting Word Table cell Information from Multiple .docx Files on an Intranet page (1 replies)
- Two Combo Boxes Active Control in the same sheet affecting each other (12 replies)
- [SOLVED:] Formula/VBA help (3 replies)
- VBA Code Indentation tool for x86 and x64 Excel (1 replies)
- How to close excel properly (3 replies)
- [SOLVED:] Copy color from range of cells (3 replies)
- How to remove duplicates within duplication sets based on criteria? (11 replies)
- Automation of email classification selection (9 replies)
- Filter and create outlook email (1 replies)
- Make the range dynamic (4 replies)
- [SOLVED:] VBA or Formula? to assign a number based on driving miles (15 replies)
- Add Usedrange property in the existing code (5 replies)
- [SOLVED:] Merging workbooks (8 replies)
- VBA Code/Macro Help (5 replies)
- Identify Font used in XLS sheet (6 replies)
- VBA Copy An Paste Only Copying 1st Row (7 replies)
- How to match index with two criterias and multiple dates? (11 replies)
- Macro to identify selected point in Excel chart (0 replies)
- Excel 2010 formula reccomendations (0 replies)
- VBA Copy/Paste Data Based Off ActiveX Dropdown Box (2 replies)
- [SOLVED:] Folders path in excel cell (10 replies)
- Help Creating a Custom Desktop Shortcut (0 replies)
- help building formula string (2 replies)
- [SOLVED:] Linking macro in one sheet to anothwer sheet (3 replies)
- [SOLVED:] Error with Find (438) (2 replies)
- [SOLVED:] Set powerpoint presentation opened from excel as active (2 replies)
- Transfer Selected Body Content from Outlook to Excel (1 replies)
- Advice needed (2 replies)
- [SOLVED:] Sending email with links disabled in sheets (11 replies)
- [SOLVED:] Transpose rows to columns (3 replies)
- [SOLVED:] Create a Copy of workbook with selected sheets (5 replies)
- [SOLVED:] Import Text Content From File - Stored in SubFolders - If It Matches File Name Col A (4 replies)
- How to express my cell range dynamically (using numbers) in VBA? (6 replies)
- [SOLVED:] VBA Clear contents help (3 replies)
- Average Function-Cannot do Copy and Drag with Quarterly Avg. Calc - Periodicity Issue (5 replies)
- [SOLVED:] Table editing (12 replies)
- [SOLVED:] Multiple lookups for string in once cell and return comma separated values (6 replies)
- VBA Deleting rows from specific cells based on some condition (31 replies)
- VBA to Delete Leading ,Trailing and Excess Spaces in Excel (2 replies)
- How to access Onedrive folder using macro / VBA? (0 replies)
- [SOLVED:] How to check if Cells has content or not (3 replies)
- [SOLVED:] VBA CellMovement from ActiveCell (3 replies)
- Help with vba (11 replies)
- [SOLVED:] Dynamic Table Array for Pivot Table in VBA (7 replies)
- Userform to Image (2 replies)
- VBA Loop Through Columns (8 replies)
- Excel VBA Queries (2 replies)
- How to save PP as pptx instead of ppt from Excel VBA (1 replies)
- VBA code to build Pivot tables in “Existing sheets”. (11 replies)
- [SOLVED:] [VBA] Copying cells from one sheet to another (6 replies)
- Return All Matching Rows On Button Press (1 replies)
- Sleeper: Scan barcode to two documents at the same time (0 replies)
- advanced filter code - subscript out of range/'Name' of object '_Worksheet' failed (3 replies)
- [ Excel ] drop down list with fixed area of dynamic table for user to enter data (4 replies)
- Breaking Powerpoint slidemaster link from Excel vba + quick macro question (6 replies)
- [SOLVED:] Align Row Content with cell format to Left column & Delete Blank row (12 replies)
- Export excel to pdf with pass (5 replies)
- ActiveX controls in office 2016 distort when design mode is off (1 replies)
- VBA Code will not search subfolders. (4 replies)
- Help with compare code (5 replies)
- Help Posting?? (9 replies)
- [SOLVED:] Finding Last Column with CF Format - Paste Previous 6 columns format to Empty Column (16 replies)
- [SOLVED:] Import from a Number of Worksheets Listed in a Column (3 replies)
- vba excel macro data between two dates (9 replies)
- Excel to Outlook Bold Text & Include Auto Signature (3 replies)
- [SOLVED:] Need help restucturing VBA Macro please! (6 replies)
- Multiple Modes (1 replies)
- [SOLVED:] Need Help: Replace all Cells of a Column with its Caption, if Cells Value is "TRUE" (5 replies)
- [SOLVED:] Need help const a VBA Macro to record 3rd and 4th digits, place in to rght in col B (7 replies)
- [SOLVED:] Extracting Form Fields from Word to Excel run-time error (2 replies)
- Need to VBA Grouping for 2500 Rows. (8 replies)
- Code Randomly works - No Pattern to when it does not work. Help Please (11 replies)
- spread repated cells (4 replies)
- [SOLVED:] Excel program & left in the lurch--please help (5 replies)
- [SOLVED:] Stripping Line Breaks (10 replies)
- Help with merging workbooks (2 replies)
- [SOLVED:] Scrolling not working for TreeView (8 replies)
- [SOLVED:] AVERAGEIF Specific cells ignoring #DIV/0! (12 replies)
- Loop through all worksheets in chosen folder to remove duplicate rows (10 replies)
- Integrate multiple filesd in a specific directory to one worksheet in a separate file (1 replies)
- Macro to Deduct and Display Time in Userform TextBox (2 replies)
- [SOLVED:] VBA Coding for Averageifs that needs to dynamically adjust over 8 quarters (6 replies)
- Help with Count if (5 replies)
- Copy down formula then remove formula from where it copied with paste it as value (6 replies)
- listobox remove item erorr (2 replies)
- [SOLVED:] Copying & Pasting Values on Same Sheet to New Table - Pasting Issues... (8 replies)
- VBA to Retrieve Information from Multiple Workbooks (0 replies)
- query close problem (1 replies)
- [SOLVED:] Multiple Lookup Criteria - Help Required (4 replies)
- [SOLVED:] Transposing each set of 22 items (all from the same column) into rows (11 replies)
- Help Converting Early Binding to Late Binding VBA Code (5 replies)
- Refine code to combine multiple CSV files into single workbook (7 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.