<div>
Thanks, I just got to the same application.transpose solution and wanted to update my question. &nbsp;And it works well and fast.<br />
I might try your other option, if you think it will be much quicker (memory wise).<br />
Regards<br />
JL
</div>


Thanks, I just got to the same application.transpose solution and wanted to update my question.  And it works well and fast.
I might try your other option, if you think it will be much quicker (memory wise).
Regards
JL

<div>
Thanks for a speedy response.
</div>


<div>
<div class="content wysiwyg-content">
I know that if you use Redim Preserve, you can only change the last dimesion of the array.<br />
So I've now got a populated array that I want to paste into an excel sheet. &nbsp;The problem is that the rows and columns are transposed.<br />
Is there an easy way (memory and speed efficient) to transpose the array's info?<br />
I thought the following could work, but doesn't....<br />
&nbsp; &nbsp; &nbsp; Range(Cells(20, 2), Cells(25, 3)) = Transpose(Arr)<br />
Arr is a two dimensional array Arr(2,6) and I want it to be Arr(6,2)<br />
Thanks<br />
JL<br />

</div>
</div>


I know that if you use Redim Preserve, you can only change the last dimesion of the array.
So I've now got a populated array that I want to paste into an excel sheet.  The problem is that the rows and columns are transposed.
Is there an easy way (memory and speed efficient) to transpose the array's info?
I thought the following could work, but doesn't....
      Range(Cells(20, 2), Cells(25, 3)) = Transpose(Arr)
Arr is a two dimensional array Arr(2,6) and I want it to be Arr(6,2)
Thanks
JL


Transpose data in an two dimensional array

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.