Blog posts

Often, especially when creating text to show to a user in a dialog, I have a Collection or Array of Strings that I want to use to inform the user of some information. Code to compile those Strings into "clean" user-friendly text can be a pain to write ... for example, making sure the penultimate and last items are delimited by "and" instead of a comma especially when you don't know how many Strings will be included from the off.

Fed up with arrays and Collections (and Dictionarys and ArrayLists)? Try List, a better collection for VBA.

Sorting arrays of Objects in VBA - any Objects, Worksheets, Documents, Slides etc or Objects defined by your own custom Class Modules

This is an implementation of the 'merge sort' algorithm - one of the most efficient sorting algorithms. It uses what's known as a 'divide...