How to get around VBA Error 6: Over Flow Error?

[Jawad77]

I am calculating the value of a variable defined as double in VBA but when i try to run the code it gives me the over flow error.

CFLW = -1 * (WL / SumW)

where CFLW, WL and SumW are variables defined as double

Can any one tell me please how to get around this error? Thanks

 

[hwkranger]

Are these numbers really large? I can't imagine a double having that problem unless you're working with a 16 digit number.

Randall Vollen
National City Bank Corp.

 

[PHV]

And what about this ?
CFLW = -(WL / SumW)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244