VBA: Delete all Excel columns except those named
Posted 16th September 2015
Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.
VBA: Create a list of all external data references in Excel
Posted 15th September 2015
Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.
Script to list image files by size and resolution, export to Excel
Posted 24th September 2014
Instructions for using PowerShell to export a list of images and their properties to Excel as a tab-delimited CSV.
Automatically update Pivot Tables in Excel
Posted 15th July 2014
A simple VBA script that refreshes (updates) all Pivot Tables within an Excel workbook after any change to a worksheet.