Update and resolution:

I had stupidly named on of my test modules as sub err() and this was where the problem lay.

I renamed it and all worked fine in the latest version of the workbook.

Epic coding fail - schoolboy error of the highest order!