Archive

2016-10-31: How to Combine Multiple Excel Workbooks into One Worksheet with VBA

2016-10-17: How to Select a Cell in One Column and Highlight the Corresponding Cell in Another Column

2016-10-02: How to Generate a GUID in Excel with VBA

2016-07-08: How to Combine Data with Different Columns on Multiple Sheets into a Single Sheet

2016-07-01: How to Check If a Collection Contains an Object

2016-06-17: How to Count and Label Duplicate Values Without COUNTIF or Range.Find

2016-06-03: How to Insert New Rows Based on Values

2016-05-27: How to Combine Data from Certain Sheets but Not Others into a Single Sheet

2016-04-29: How to Create a MEDIANIFS User-Defined Function with VBA

2016-04-22: How to Open Semicolon-Delimited TXT Files and Convert Them to XLS Files

2016-04-15: How to Click One Cell and Highlight Another

2016-04-08: How to Create a VBA Function and Re-use it in Many Subroutines

2016-04-01: How to Copy Data Based on Dates: Part 2, an Existing Worksheet

2016-03-24: How to Copy Data Based on Dates: Part 1, a New Worksheet

2016-03-10: How to Extract Unique Values from ANYTHING in Excel with VBA

2016-02-23: The Only Progress Bar You Will Ever Need

2016-02-02: How to Combine Data from Multiple Sheets into a Single Sheet

2016-01-26: How To Delete Rows With Range.AutoFilter

2016-01-22: How To Delete Rows With a For Loop

2015-10-26: How to Create Zip Files with VBA using 7-Zip

2015-09-20: How to Run a Batch File and Wait Until It Finishes with VBA

2015-09-06: How to Move Data from Input Sheet to Variable Sheets Based on User Input

2015-09-04: How Do I Save Multiple Sheets as a Single PDF

2015-08-29: How to Copy Data to a New Workbook Based on Dates

2015-08-26: How to Transpose Horizontal Data to Vertical Data for Easy Pivot Tables

2015-08-23: How Can You Extract Several Values from a String?

2015-08-12: How To Speed Up Delete Row Loops

2015-07-05: Combining Many Excel CSV Files Into One Part 3

2015-06-24: Combining Many Excel CSV Files Into One Part 2

2015-06-23: Combining Many Excel CSV Files Into One Part 1

2015-06-17: Deleting Blank Rows in a Variable Range with VBA

2015-06-12: Combining Data and Transposing the Results to Rows not Columns with VBA

2015-06-10: Converting Numbers like YYYYMMDD to Dates with VBA

2015-06-07: Create a New Column Based on a Different Column with VBA