Microsoft Office Tutorials and References
In Depth Information
16.1.8 Members that Produce Actions
ShowChartTipValues property (R/W Boolean)
When this property is True , its default value, Excel charts show chart tip values.
ShowToolTips property (R/W Boolean)
When this property is True , its default value, ToolTips are turned on.
StandardFont property (R/W String)
This property returns or sets the name of the standard font. Note that the change does not
take effect until Excel is restarted.
StandardFontSize property (R/W Long)
This property returns or sets the standard font size, in points. The change does not take
effect until Excel is restarted.
StartupPath property (Read-Only String)
This property returns the complete path of the startup folder, excluding the final separator.
TemplatesPath property (Read-Only String)
This property returns the path where templates are stored.
16.1.8 Members that Produce Actions
Several members of the Application object perform some sort of action.
16.1.8.1 ConvertFormula method
This method converts cell references in a formula between the A1 and R1C1 reference styles. It
can also convert between relative and absolute references. Its syntax is:
Application.ConvertFormula( Formula , FromReferenceStyle ,
ToReferenceStyle , _
ToAbsolute , RelativeTo )
The Formula parameter is a string containing the formula to convert. It must be a valid formula,
beginning with an equal sign.
The FromReferenceStyle parameter must be one of the following constants:
Enum XlReferenceStyle
xlR1C1 = -4150
xlA1 = 1
End Enum
The optional ToReferenceStyle parameter is the reference style into which to convert the
formula. It is also one of the XlReferenceStyle constants. If we omit this argument, the
reference style is not changed.
Search JabSto ::




Custom Search