Error in printing 1D Array

Hi all,

I have range of data Range("A1:Z10000"). I want to consolidate it into a single column.
The array looks ok, but I have trouble printing it out. Only the first element of the array got printed.
Any help, comments or guidance are greatly appreciated.

Please Login or Register  to view this content.

See how I did it in: http://www.excelforum.com/excel-prog...o-another.html

Thank you all for your input. I just thought of something but not sure if it's even possible. Since there are a total of 260,000 elements in the array, and the Transpose function only allows 70,000 elements to be printed.
If I take 260,000 / 4 = 65,000 then is it possible to print 65,000 elements at a time?
I want to stick with the variant array because of its speed.

I cant get the syntax right for the last 4 lines of code ( the printing part )

Please Login or Register  to view this content.

I don't see the issue.

Please Login or Register  to view this content.

Sorry, I reduced the size of the dataset. It doesn't work with the full size of the dataset. I was hoping if could write the array out in 4 increments to overcome the Transpose limitation.

Something like:
nuArr( 1 to 65000)
nuArr(65000 to 130000)
nuArr(130000 to 195000)
nuArr(195000 to 260000)