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