Post the code please. The overflow may be caused by something else that the
receiving variable.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Srdjan Kovacevic" skrev i melding
...
Hi,

I'm having problems finding data type that will sustain big numbers (10 or
more digits). My prog (simple LCG/MLCG random number generator) works best
with Long data type, but even then it's quite limited in terms of size of
the numbers it can crunch. Apparently, Variant data type should allow
bigger
numbers (Excel help says: "Numeric data can be any integer or real number
value ranging from -1.797693134862315E308 to -4.94066E-324 for negative
values and from 4.94066E-324 to 1.797693134862315E308 for positive
values"),
but when I declare my variables as Variant, the prog reports "overflow"
even
for the parameters that Long variable can crunch.

Thanks
srdjan