Why am I getting an overflow error on 365 * 100?

[Al Smith]

Hi,

Why is the following code gives me an overflow error?

Dim XYZ As Double
XYZ = 365 * 100
Debug.Print XYZ

I've also dimmed XYZ as Long, and Single and still get the error.

Thanks,
Al.

[theman32x]

i tried

Dim a As Long
Dim b As Long
Dim c As Long
a = 100
b = 365
c = a * b
Print c

that works but don't know if that's what you wanted

[Edited by theman32x on 08-26-2000 at 01:01 PM]

I am having a majorly hard time understanding this but MSDN recommends trying this:

Dim XYZ As Double
XYZ = CDbl(365) * 100
Debug.Print XYZ

and it appears to work, just dont ask me why!


[Edited by wossname on 08-26-2000 at 01:41 PM]

[theman32x]

you must use the CDbl function on it to explicitly make the parameter a Double

??????????????????????????????
would your code be a parameter
??????????????????????????????

[Edited by theman32x on 08-26-2000 at 04:11 PM]