View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
j17stang66 j17stang66 is offline
external usenet poster
 
Posts: 6
Default 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.