Seach VBA's help for DataType.

Look at Double (and single).

You'll see that each help ends with a statement like:

The type-declaration character for Double is the number sign (#).

and

The type-declaration character for Single is the exclamation point (!).

I think you just got some help from the VBE since you typed in the decimal point
and 0.

=======
From the VBE's immediate window:

?typename(5#)
Double

?typename(5.0#)
Double

?typename(5.0)
Double

?typename(5)
Integer





Joel wrote:

Dave: I'm not sure. This is what I did this afternoon.

Dim abc As Single
abc = 5.0

Excel changed the 5.0 to 5#.

"Dave Peterson" wrote:

You sure it doesn't mean double?



Joel wrote:

# indicates the number is single precision, not an integer.

"Luis Fernando Ortiz M." wrote:

Hi everybody,

In a pice of code I found this expression.

Case Is < 2000000000000#

Wath means an what is the function of "#"

Regards,


--
Luis Fernando Ortiz Maldonado




--

Dave Peterson


--

Dave Peterson