I need to build a array that is quite large. (12500 items or more) When I redim or even declare the array of a UBound greater than 9500 I get a "Out of Memory Error" (Run time error 7).

Is there a limit to the amount of items a attay can hold? Is there another way to handle this large amount of data?

Public MyArray() as string

Redim(10000,10000)

Any information would be appreciated.

Thanks Strevy