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.

Duplicate Excel cells multiple times

Posted 13th April 2016

No comments

Use this Visual Basic script in Microsoft Excel to duplicate cells a specified number of times.

Read the full story...

Rearrange Excel columns via Visual Basic

Posted 16th March 2016

17 comments

A simple VBA script for rearranging the order of columns in an Excel spreadsheet.

Read the full story...

VBA: Test if a font is installed when a Word file opens

Posted 3rd December 2015

No comments

If a required font is missing, this script will alert a user that the font needs to be installed on their local computer before a Microsoft Word file will display properly.

Read the full story...

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

VBA: Delete all Excel columns except those named

Posted 16th September 2015

2 comments

Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.

Read the full story...

VBA: Create a list of all external data references in Excel

Posted 15th September 2015

3 comments

Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.

Read the full story...

VBA: List all formulae in an Excel workbook

Posted 2nd July 2015

1 comment

Described is a convenient method for using VBA scripts to extract every formula from a Microsoft Excel workbook and create a list of them in a separate sheet for later reference or backup.

Read the full story...

Easily generate Code 128 barcodes in Excel

Posted 29th May 2015

65 comments

This simple methodology can be employed to reliably generate Code 128 barcodes in Excel.

Read the full story...

Open and close Excel workbooks in the background

Posted 4th September 2014

2 comments

Use a Visual Basic for Applications (VBA) script to open secondary Excel workbooks as data sources when opening a VLOOKUP-dependent workbook.

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