Collections Overflow

[jms08h]

All problems fixed.
Administrator, please delete.

[Bob Phillips]

Try CLng instead of CInt

[Zack Barresse]

jms08h, in the future please refrain from editing your post on your own. Repeated attempts of doing this will surely have the proverbial forum reprocussions come down up on you from internet heaven. In other words, now your post makes zero sense. We archive our threads. Please just pm a moderator if you want the post deleted (we'll just accordingly, just talk to us first).

[Paul_Hossler]

Actually, if it were just marked 'Solved' instead of deleting it, the rest of us could learn something also.

My 2 cents,

Paul

[Zack Barresse]

That's absolutely the idea, Paul. It's mostly the reason why we originally instituted the 'Mark Solved' on this board, somebody can search for their current problem and know somebody has solved it in some fashion.

xld may be able to shed more light on the original problem, but I imagine (from the solution) the wrong type of variable was used, thus an Overflow error was produced. From Excel help..

Long (long integer) variables are stored as signed 32-bit (4-byte) numbers ranging in value from -2,147,483,648 to 2,147,483,647.

Integer variables are stored as 16-bit (2-byte) numbers ranging in value from -32,768 to 32,767.