I am working with a large file, calculating and printing the results to an array. Once all the calculations are done I print the results to the worksheet. Now the end result may take up more than the 56K limit for using transpose so now I am stuck with only a few options:
1) Redim the 2nd dimension (e.g. 1 to 5, 1 to 100000) and then use a loop to exchange all the first dimension elements with the second dimension elements thereby transposing the array
2) Starting off with a huge array from the start (e.g. 1 to 100000, 1 to 5) which is inefficient
I have thought that it might be possible to create a jagged array with each element consisting of two-dimensional arrays (1 to 5, 1 to 56000) and then internally transpose to print to sheet.
This is all theoretical and it might not be possible to redim a jagged array or transpose an element with a jagged array.
If anyone has knowledge or experience with this or another workaround, please let me know.
Thanks.
abousetta
Bookmarks