VBA Overflow error

[aculham]

Hello. I am having the following problem in a VBA macro i have written. I declare a bunch of variables and arrays, mostly longs and doubles, then run a DLL. After that, I redim one of my arrays (2D) to the right size and try to fill in some values. The array is a double and the values are less than one million. On the first element the code breaks and throws an overflow error. If I choose "Debug", I can then click continue and it finishes just fine as if there was no error. I can see in the debugger that the array is sized properly, has the correct type, etc. I have no idea what could be wrong here. Could it be a memory problem? Thanks in advance.

 

[jindon]

Are you sure, it is because of that line ?

myArray(1,1) = 1#

 

[aculham]

If I try to assign any value to myArray(i,j) it throws an error (for any i and j in the appropriate range). When it does, I tell it to debug and it takes me to that line. I am then able to hit "continue" and it finishes just fine. I even tried rebooting my machine and still nothing.

 

[RoryA]

Can we see the full declaration lines? How are i and j declared for instance and what are/should be their values at the time of the error?

 

[aculham]

The code is huge so I won't post it all here. i and j are of type Long. But just in case I tried doing myArray(1,1) = 1 or 0 or 3.14159. None of them work.