Runtime error: 13 mismatch in complicated VBA array

[p45cal]

I wonder if 32 bit or 64 bit Excel makes a difference?

With 64bit Windows and 64bit MS365 I get the same results as msg#16
For me, I try always to avoid using TRANSPOSE in vba;

• it's faster to loop and
• transpose converts the data type Date to String, leaving it to Excel and whatever locale it's working in to re-interpret those date strings to dates proper.