Skip to content

Combining R1C1 and A1-style cell referencing in Excel

G11th May 2015 

C3 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

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

Open and close Excel workbooks in the background

G4th September 2014 

C2 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

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

Automatically select data-containing cells in Excel

G29th January 2014 

CNo 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

G24th January 2014 

CNo comments

Use VBA to create or delete worksheets in Microsoft Excel.

Read the full story

Automatically number rows in Excel

G16th January 2014 

CNo 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