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.
Automatically select data-containing cells in Excel
Posted 29th January 2014
This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.