View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Arrays: Subscript out of range

nortor,
Check you value of cnt2.
It should have a maximum value of cnt1-1, by the time the error occurs.

NickHK

"nortor" wrote in message
...
Hello!

This line (fifth last one)

myArray(i, j) = dSett2(i - 1, (9 + j))

i is then 1933 and j is 1

I think the error is in the last part(after the equal sign)


Cheers
NorTor



On Wed, 16 Feb 2005 20:13:17 GMT, Tushar Mehta
wrote:

What line generates the error? What is/are the value/s of the
subscript/s at that point?