Posted 11th May 2015
Use R1C1 cell referencing in Excel equations whilst the programme is still set to A1-style.
Posted 21st January 2015
Some simple VBA code to add columns in Excel, insert specific formulae at the top then fill-down to the bottom of the sheet.
Posted 29th January 2014
This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.
Posted 24th January 2014
Use VBA to create or delete worksheets in Microsoft Excel.