PDA

View Full Version : Collections Overflow



jms08h
07-16-2009, 09:00 AM
All problems fixed.
Administrator, please delete.

Bob Phillips
07-16-2009, 09:02 AM
Try CLng instead of CInt

Zack Barresse
07-19-2009, 07:35 PM
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
07-20-2009, 06:35 AM
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
07-21-2009, 08:42 AM
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.