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.

Easily generate Code 128 barcodes in Excel

Posted 29th May 2015

75 comments

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

Read the full story...

Combining R1C1 and A1-style cell referencing in Excel

Posted 11th May 2015

3 comments

Use R1C1 cell referencing in Excel equations whilst the programme is still set to A1-style.

Read the full story...

Automatically add columns and formulae then fill-down in Excel

Posted 21st January 2015

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

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

Add a suffix to selected cells in Excel

Posted 12th July 2014

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

Automatically select data-containing cells in Excel

Posted 29th January 2014

No comments

This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.

Read the full story...

Automate the creation or deletion of worksheets in Excel

Posted 24th January 2014

No comments

Use VBA to create or delete worksheets in Microsoft Excel.

Read the full story...

Automatically number rows in Excel

Posted 16th January 2014

No comments

Use a simple Visual Basic for Applications (VBA) script to automate the process of numbering new rows in Microsoft Excel.

Read the full story...