VB Forum / COM / June 2005

Why not re-write your program to use Doubles instead of Longs? Just be aware
that this *could* introduce floating point discrepencies that you'd need to
deal with (if you'll only be assigning integer values to Double data types,
then you don't need to worry about it).  A Double's range is
4.94065645841247E-324 to 1.79769313486232E308 (for positive numbers).

You could also use a Decimal, which has a range of
+/-79,228,162,514,264,337,593,543,950,335 (if no decimal point). The Decimal
data type is actually a Variant.  Use the CDec function to convert to a
Decimal subtype.

If you need numbers outside those ranges, then VB is probably not the
language you should be using.

Dim variable as Double?

- Kev