Larger Data Container Than Array Needed

[markronz]

Hello,
Does anyone know of a data container that is larger than an array. My VBA program I am working on in Excel tells me that it is out of memory. Sometimes it's that I have too many results, other times it's that my individual results are too large (contain too much text). So does anyone know of a data type that would be bigger, yet still have the same or simlilar functionality?

Thanks
-Mark

 

[PHV]

Perhaps a Scripting.Dictionary object ?
You'll need to add a reference to the Microsoft Scripting Runtime in your project.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886