Skip to content

Duplicate Excel cells multiple times

G13th April 2016 

CNo comments

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

Read the full story

RGB to HEX in Excel

G24th March 2016 

C7 comments

Use Microsoft Excel to convert Red-Green-Blue (RGB) values into hexadecimal colour codes and display the relevant colour graphically beside each output.

Read the full story

Rearrange Excel columns via Visual Basic

G16th March 2016 

C12 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

G3rd December 2015 

CNo 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: Convert text to columns for all worksheets in Excel

G26th November 2015 

C4 comments

A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.

Read the full story

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

VBA: Delete all Excel columns except those named

G16th September 2015 

C2 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

G15th September 2015 

C3 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

G2nd July 2015 

C1 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

G29th May 2015 

C39 comments

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

Read the full story