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.
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.
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.
Automatically update Pivot Tables in Excel
Posted 15th July 2014
No comments
A simple VBA script that refreshes (updates) all Pivot Tables within an Excel workbook after any change to a worksheet.
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.
Automatically select data-containing cells in Excel
Posted 29th January 2014
No comments
This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.
Automate the creation or deletion of worksheets in Excel
Posted 24th January 2014
No comments
Use VBA to create or delete worksheets in Microsoft Excel.
Automatically number rows in Excel
Posted 16th January 2014
No comments
Use a simple Visual Basic for Applications (VBA) script to automate the process of numbering new rows in Microsoft Excel.