Let's Talk Excel

Category Archives: VBA

VBA Code to list files from a folder containing a string
February 6, 2015

The code bellow asks for a folder location, and then for a string. Then it searches through the files in that folder and returns a list of those, that contain the ...

Save Each Excel Sheet To A Separate File
January 30, 2015

This VBA code saves each Worksheet in the active Excel Workbook to a separate file and even lets you decide whether to keep the formulas on the sheets or change them ...

Open All Excel Files In A Folder
January 23, 2015

This is a short but sweet VBA code that let’s you open all Excel files in a folder without having to select them all. The code asks you for a folder location ...

Create a new Custom List from selected Cells
January 16, 2015

Custom lists are very useful in Excel because they are a quick way to get multiple entries into cells and sort pivot tables in the desired manner. They are ...

Copy Excel Sheet Print Settings To all Sheets
January 9, 2015

Imagine having many Sheets in a workbook. Now you would like all of them to print in a same way. Let’s say with the same header and footer. Many people do this ...

Sorting Sheets by name or tab color
January 2, 2015

This is a functionality that is missing from Excel and can only be achieved by VBA code. Two such samples are listed below. The first will allow you to sort sheets ...