Playing around with the sizes of my arrays I got an error message that made
sense. I was defining all of my Public variables in one module, which VBA
didn't like because it can only handle 64k worth of declarations in any given
module. So, I split up my declarations into 4 modules and things seem to be
working.

"Dana DeLouis" wrote:

I don't think that the error is caused by a wrong reference. The array
size
is a 1x12 (1 to 12) representing months and is filled with For loops
with an
integer count mnI from 1 to 12.

If you are having a problem with a size 12 array, one technique is to step
thru your code (hit F8)
and pull up your "Locals Window" to view your variables and Arrays.
This is one debugging technique.
Perhaps post a short segment of your code.

--
Dana DeLouis


"j17stang66" wrote in message
...
I don't think that the error is caused by a wrong reference. The array
size
is a 1x12 (1 to 12) representing months and is filled with For loops
with an
integer count mnI from 1 to 12.

I think the error message is a symptom of something else, please see
initial
message.

" wrote:

j17stang66, Esq.

"Subscript out of range ......" ; it may mean that for an array sized
100, a reference has been attempted outside that range of 100.

Please re-examine your code that causes the exception.

Regards.