Duplicate Excel cells multiple times
Posted 13th April 2016
No comments
Use this Visual Basic script in Microsoft Excel to duplicate cells a specified number of times.
Rearrange Excel columns via Visual Basic
Posted 16th March 2016
22 comments
A simple VBA script for rearranging the order of columns in an Excel spreadsheet.
VBA: Test if a font is installed when a Word file opens
Posted 3rd December 2015
No comments
If a required font is missing, this script will alert a user that the font needs to be installed on their local computer before a Microsoft Word file will display properly.
VBA: Automatically format specific text in Microsoft Word
Posted 14th October 2015
2 comments
Use this simple Visual Basic for Applications (VBA) script to reformat any text string within Microsoft Word.
VBA: Delete all Excel columns except those named
Posted 16th September 2015
2 comments
Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.
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.
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.