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?