Skip to content

VBA: Automatically format specific text in Microsoft Word

G14th October 2015 

C1 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

G21st January 2015 

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

Read the full story

Automatically update Pivot Tables in Excel

G15th July 2014 

CNo 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

G12th July 2014 

C2 comments

Use this handly VBA macro to automatically add characters to the end of values in a selected range of cells.

Read the full story