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: Automatically format specific text in Microsoft Word

Posted 14th October 2015

1 comment

Use this simple Visual Basic for Applications (VBA) script to reformat any text string within Microsoft Word.

Read the full story...

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.

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...

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.

Read the full story...