Memory limits

[groston]

I run Excel version 14.0.4760.1000 (32 bit) which is a part of MS Office Professional 2010. My macro creates some very large two dimensional arrays of integers. The size of the second parameter is 13, but I had to limit the size of the first parameter to 11,000,000 because if the array gets somewhat larger than that, an out of memory error is thrown.

Question: Is it possible to tweak something so that the array can be larger?

[arnelgp]

so there are 13 columns and 11 million rows?
you might find using recordset interesting.

[groston]

I 'cheated' - rewrote the code to add the rows to a new spreadsheet every 500,000 rows; so hopefully things never get too large.