Hi georgiboy.
I sat in front of my laptop for nearly five hours and I just could not see what was wrong.
I would never have thought of the TRANSPOSE function being the issue as I was, wrongly, blinkered in the
mindset of a literal conversion of the formula to VBA without considering the steps needed.
This afternoon I have tested it in my example workbook, and in the final workbook.
Thank you, it works perfectly and is almost instantaneous filling in data down 91,304 rows.
I could not have asked for a better result.
Thank you again for your kind help.