Excel, Hash (#) in VBA Calculations

[SMS - John Howard]

Hi Folks,

I have recently inherited care of an Excel XP model that contains the
following calculations, containing the # symbol.

Amount = Amount / 100#
NewValue = OldValue * -1#

I can see where the variables Amount, NewValue and Old Value are declared
but nothing on the #.

The end results sor t of make sense if the # symbols were in fact the %
sign. Other than that I am totally confused.

Does this use of the # symbol make sense to anyone.

TIA

John Howard
Sydney, Australia

 

[Rob van Gelder]

It is whats referred to as a Type Declaration Character.

It means that when the expression is evaluated, the number in front of the
type declaration character is treated as a specific data type instead of as
a Variant.

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

The list of type declaration characters are:
Integer %
Long &
Currency @
Single !
Double #
String $

 

[SMS - John Howard]

Rob,
Many thanks.
That certainly makes sense and puts everythng in place

Best regards

John