![](https://code.adonline.id.au/wp-content/uploads/excel-logo-2013-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/excel-2013-150x150.png)
Automatically select data-containing cells in Excel
Posted 29th January 2014
No comments
This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.