+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Marilyn Kilian
    Guest

    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.


  2. #2
    Dave Peterson
    Guest

    Re: 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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1