Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Box With REPLY appended To A Cell: What Is It ? | New Users to Excel | |||
File names appended with ~ plus alphanumeric characters | Excel Discussion (Misc queries) | |||
appended a cell, but need to keep decimal places | Excel Discussion (Misc queries) | |||
remove cr character from a + number and change number to - 159cr | Excel Worksheet Functions | |||
Pivot Table DataFields are appended with a '2', why? | Excel Discussion (Misc queries) |