![](https://code.adonline.id.au/wp-content/uploads/excel-logo-2013-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/excel-2013-150x150.png)
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.
![](https://code.adonline.id.au/wp-content/uploads/icon_microsoft_word_2013-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/icon_microsoft_word_2013-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/excel-logo-2013-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/excel-logo-2013-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/excel-logo-2013-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/barcode-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/excel-logo-2013-150x150.jpg)
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.
![](https://code.adonline.id.au/wp-content/uploads/excel-logo-2013-150x150.jpg)
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.