Maximum number of variables allowed in Excel VBA
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.
|