Skip to content

VBA: Convert text to columns for all worksheets in Excel

G26th November 2015 

C5 comments

A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.

Read the full story

VBA: Automatically format specific text in Microsoft Word

G14th October 2015 

C1 comment

Use this simple Visual Basic for Applications (VBA) script to reformat any text string within Microsoft Word.

Read the full story

Applying dates to normalised data in Excel

G19th July 2015 

CNo comments

Use this formula to apply dates to all variables in a normalised linear list data set in Excel.

Read the full story

Blog post thumnail

Conditional Comments in CSS for Internet Explorer

G25th September 2011 

C1 comment

Using conditional comments within cascading style sheets to target specific versions of Microsoft Internet Explorer.

Read the full story