XL97: Number Signs (#) May Appear in Recorded Macros

   ActiveSheet.Shapes.AddShape(msoShapeRectangle, 27.75, 6#, _
       223#, 118#).Select
				

MORE INFORMATION

In Visual Basic for Applications, number signs are used to indicate that the number to which they are attached is the Double type, for example:

   115#
				

When you record a Visual Basic for Applications macro, Microsoft Excel may automatically set recorded numbers that are whole numbers to the Double type by adding a number sign after each number. This behavior does not affect the functionality of the macro in any way.

You can also observe this behavior by typing the following subroutine into a new Visual Basic module:

   Sub Test()

       Dim X As Integer
       X = 3.0 + 5.0

   End Sub
				

When you enter the third line of code, the values in the line are converted into the Double type:

   X = 3# + 5#
				

This is an automatic feature in Visual Basic for Applications. If you enter the following line of code instead

   X = 3 + 5
				

the values are not converted into the Double type, because the values do not end in ".0."