Quote Originally Posted by georgiboy View Post
I think this is due to the limitations of the TRANSPOSE function, try it as below where the need for this function has been removed.
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.