Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

VBA: Delete all Excel columns except those named

Posted 16th September 2015

2 comments

Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.

Read the full story...

VBA: Create a list of all external data references in Excel

Posted 15th September 2015

3 comments

Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.

Read the full story...

Script to list image files by size and resolution, export to Excel

Posted 24th September 2014

9 comments

Instructions for using PowerShell to export a list of images and their properties to Excel as a tab-delimited CSV.

Read the full story...

Automatically update Pivot Tables in Excel

Posted 15th July 2014

No comments

A simple VBA script that refreshes (updates) all Pivot Tables within an Excel workbook after any change to a worksheet.

Read the full story...