VBA: Automatically format specific text in Microsoft Word
Posted 14th October 2015
Use this simple Visual Basic for Applications (VBA) script to reformat any text string within Microsoft Word.
Automatically add columns and formulae then fill-down in Excel
Posted 21st January 2015
Some simple VBA code to add columns in Excel, insert specific formulae at the top then fill-down to the bottom of the sheet.
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.
Add a suffix to selected cells in Excel
Posted 12th July 2014
Use this handly VBA macro to automatically add characters to the end of values in a selected range of cells.