What does the '#' character mean when appended to a number?
 

I recorded a macro while adding a shape (rectangle) to an Excel chart:

Sub box2()
'
' box2 Macro
' Macro recorded 1/8/2006 by mk2968
'

'
ActiveChart.Shapes.AddShape(msoShapeRectangle, 13.5, 103#, 59.5, 43#). _
Select
ActiveChart.ChartArea.Select
ActiveChart.Shapes("Rectangle 16").Select
Selection.ShapeRange.ScaleHeight 1#, msoFalse, msoScaleFromBottomRight
ActiveChart.ChartArea.Select
End Sub

What do the '#' characters indicate? I can't find in the documention. Thanks.

What does the '#' character mean when appended to a number?
 

Search VBA's help for "Double Data Type" and you'll see this:

Double (double-precision floating-point) variables are stored as IEEE 64-bit
(8-byte) floating-point numbers ranging in value from -1.79769313486231E308 to
-4.94065645841247E-324 for negative values and from 4.94065645841247E-324 to
1.79769313486232E308 for positive values. The type-declaration character for
Double is the number sign (#).



Marilyn Kilian wrote:

I recorded a macro while adding a shape (rectangle) to an Excel chart:

Sub box2()
'
' box2 Macro
' Macro recorded 1/8/2006 by mk2968
'

'
ActiveChart.Shapes.AddShape(msoShapeRectangle, 13.5, 103#, 59.5, 43#). _
Select
ActiveChart.ChartArea.Select
ActiveChart.Shapes("Rectangle 16").Select
Selection.ShapeRange.ScaleHeight 1#, msoFalse, msoScaleFromBottomRight
ActiveChart.ChartArea.Select
End Sub

What do the '#' characters indicate? I can't find in the documention. Thanks.

--

Dave Peterson