I try to find a MS article for things like this, but this is the best I found


https://www.ablebits.com/office-addi...536%20elements.


Note. Transposing with VBA, has a limitation of 65536 elements. In case your array exceeds this limit, the extra data will be silently cast away.