You can easily overload a double...

Sub OverflowDouble()
Dim d#
d = CDbl(1E+308) * 2#
End Sub

is that helpful?



--
Regards,
Tom Ogilvy

"keepITcool" wrote in message
.com...

You can easily overload a long...

Sub OverKill()
Dim d#, l&
d = 1E+100
l = d
End Sub


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote in

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