VBA: Convert text to columns for all worksheets in Excel
Posted 26th November 2015
A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.
VBA: Automatically format specific text in Microsoft Word
Posted 14th October 2015
Use this simple Visual Basic for Applications (VBA) script to reformat any text string within Microsoft Word.
Applying dates to normalised data in Excel
Posted 19th July 2015
Use this formula to apply dates to all variables in a normalised linear list data set in Excel.
Conditional Comments in CSS for Internet Explorer
Posted 25th September 2011
Using conditional comments within cascading style sheets to target specific versions of Microsoft Internet Explorer.