Maximum Size of a VBA Array in Excel 2007 | Windows Secrets Lounge

I'm running into a problem that I think is caused by exceeding the maximum size of a VBA array in Excel 2007. The final size of the array is (201185 x 151) The procedure works fine with smaller data sets - but when I move to the larger data set, the final

windowssecrets.com