Hi,
I'm a reader of Excel 2002 VBA programmer's reference. I'm writing a financial bond model with lots of variables. For example, I have a object composed of 4 arrays. Each array has 480 double numbers. After I define two objects, the system told me the local memory allocation is full. However, I need to allocate 25 objects. Is there any way to bypass this limitation. P.S.: If I allocate those object as global objects, they are fine. However, these objects aren't supposed to be global objects. Thank you.

Tracy

I'm new to this, but did you try to put arrays in different modules, and call them in a "master module" ?