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 24th September 2014
Instructions for using PowerShell to export a list of images and their properties to Excel as a tab-delimited CSV.
Posted 1st July 2014
Instructions for using a Windows PowerShell script to compile computer file data and export the results to Excel as a tab-delimited CSV.
Posted 29th January 2014
This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.