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

G

Guest

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.
 
D

Dave Peterson

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 (#).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top