This is a guest post by Craig Hattabaugh, CIMCON Software CEO and is meant to accompany  the video clip – http://blog.cimcon.com/blog/excel-office-romance also on YouTube ...

It’s Friday the 13th, so a perfect day for an Excel quiz 🙂

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 given string. At this point, it ...

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 to values. When you run the ...

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 and it does the rest :). At the ...

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 constantly used to get a sequence of ...

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 by selecting all the sheets ...

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 alphabetically in Excel. The ...