Posted 15th September 2015
Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.
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.