What's the number. What happens if you change the type to Long.

--
Regards,
Tom Ogilvy

"cbh35711" wrote in
message ...

The subject pretty much sums it up.
I've got a number in a cell that i want to divide by 3, but for some
reason i keep getting an overflow error when i try to save a number
from a cell into a variable. The variable is an int, and the number
shouldn't be too big to fit.

Thanks for the help,

Chris


--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile:
http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=566328