I am receiving a "Run-time error '9': Subscript out of range" after declaring
and using a block of array variables. This recently started when I expanded
from 1508 to 1593 "Public" array variables with a total of around 2000 total
variables (arrays and other types) in the operations model.

I tried to change the "Double" variables to "Single" thinking it was a
memory issue, no change. Tried on multiple machines and in Excel 2000 and
2003 with the same results.

The variable that the error refers back to is the first array variable to be
set and has worked without a problem until now.

What is the maximum number of arrays allowed within VBA? Is there any
setting within Excel that can be changed to fix this? Does 2007 allow for
more variables?

Thanks,
James