Error in printing 1D Array

[Xceller]

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.

[Kenneth Hobson]

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

[TMS]

I think you'd need to use Transpose to get the array out but, as I recall, there is a limitation on the number of cells that you can transpose.

Please Login or Register  to view this content.

The code above works with 26 columns and 2520 rows. After that, you get an error ... hence the error handling.


Regards, TMS

[millz]

If your objective is to combine into a single column, why not just copy pasta?

Please Login or Register  to view this content.

[Xceller]

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.

[Kenneth Hobson]

I don't see the issue.

Please Login or Register  to view this content.

[Xceller]

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)