Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
# added to number in function procedure
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
# added to number in function procedure
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] Erin wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
# added to number in function procedure
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] Erin wrote: 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to run external workbook function/procedure? | Excel Discussion (Misc queries) | |||
Create a procedure or function | Excel Worksheet Functions | |||
Error: The procedure number is out of range | Excel Programming | |||
Calling a Custom Function within a Procedure | Excel Programming |