# added to number in function procedure

E

Erin

Hi All,

Does anyone know why VBA would add a # after a number.

I type in:

anNewIP = anNewIP + 2147483648

And when I move to the next line the code changes to:

anNewIP = anNewIP + 2147483648#

I've never seen this before.

Thanks.
 
J

Jake Marx

Hi Erin,

I can tell you what's happening, but not why. Maybe someone else can fill
in the gaps. A Long Integer only goes to 2,147,483,647. When you type the
next number up, VBA adds a # to the end, which is the type-declaration
character for a Double. Maybe since you typed what looks like an integer,
VBA adds the # to let you/itself know that the value must be represented as
a floating point value instead. FWIW, if you add a decimal fraction to the
number, VBA does not add the #.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
E

Erin

Thanks, Jake. That explains it. Sure enough it doesn't
happen with 2147483647. Interesting.
-----Original Message-----
Hi Erin,

I can tell you what's happening, but not why. Maybe someone else can fill
in the gaps. A Long Integer only goes to 2,147,483,647. When you type the
next number up, VBA adds a # to the end, which is the type-declaration
character for a Double. Maybe since you typed what looks like an integer,
VBA adds the # to let you/itself know that the value must be represented as
a floating point value instead. FWIW, if you add a decimal fraction to the
number, VBA does not add the #.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Hi All,

Does anyone know why VBA would add a # after a number.

I type in:

anNewIP = anNewIP + 2147483648

And when I move to the next line the code changes to:

anNewIP = anNewIP + 2147483648#

I've never seen this before.

Thanks.
Click to expand...

.
Click to expand...
 
Top