Dim as Decimal?

Varient

From the Help File

Decimal data type
A data type that contains decimal numbers scaled by a power of 10. For zero-scaled numbers, that is, numbers with no decimal places, the range is +/-79,228,162,514,264,337,593,543,950,335. For numbers with 28 decimal places the range is +/-7.9228162514264337593543950335. The smallest non-zero number that can be represented as a Decimal is 0.0000000000000000000000000001.

Note that at this time the Decimal data type can only be used within a Variant. You cannot declare a variable to be of type Decimal. You can, however, create a Variant whose subtype is Decimal using the CDec function.

Generally, it's a bad idea to use Variants when the same data can be captured by one of the other data types. The more frequently you use them, the slower in general your program will be.

In this case, two alternatives are Single and Double.

Dim x as Single
Dim y as Double <-- Recommended

You should almost always use the Double type for decimal numbers. It has both a larger range and higher precision. Since disk storage is generally cheap and RAM rather plentiful, there are really no advantages to using Single. (Of course, if you're dealing with some high volume application with specific conditions... maybe; but most everyday users will never encounter such a situation.)


Scott