VBA: Create a list of all external data references in Excel
Posted 15th September 2015
4 comments
Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.
VBA: List all formulae in an Excel workbook
Posted 2nd July 2015
2 comments
Described is a convenient method for using VBA scripts to extract every formula from a Microsoft Excel workbook and create a list of them in a separate sheet for later reference or backup.
Easily generate Code 128 barcodes in Excel
Posted 29th May 2015
80 comments
This simple methodology can be employed to reliably generate Code 128 barcodes in Excel.
Combining R1C1 and A1-style cell referencing in Excel
Posted 11th May 2015
4 comments
Use R1C1 cell referencing in Excel equations whilst the programme is still set to A1-style.
INDEX MATCH instead of VLOOKUP
Posted 22nd January 2015
1 comment
INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.
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.
VLOOKUP in Excel with multiple criteria
Posted 3rd December 2014
No comments
An alternative to VLOOKUP in Excel that permits a search based on multiple criteria.
Script to list image files by size and resolution, export to Excel
Posted 24th September 2014
9 comments
Instructions for using PowerShell to export a list of images and their properties to Excel as a tab-delimited CSV.
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.
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.