Int is not going to accept
your value if it has decimals.


I couldn't reproduce that:

b% = 8/7
? b%
1
? typename(b)
Integer


It certainly won't hold the decimal portion, but that won't cause an
overflow error.

--
Regardes,
Tom Ogilvy



"Excelenator"
wrote in message
...

Try changing the variable type to Double. Int is not going to accept
your value if it has decimals.


--
Excelenator


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