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


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