VBA: Automatically format specific text in Microsoft Word
Posted 14th October 2015
2 comments
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
5 comments
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
No comments
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
2 comments
Use this handly VBA macro to automatically add characters to the end of values in a selected range of cells.