ReferenceStyle Property
Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write XlReferenceStyle.
XlReferenceStyle can be one of these XlReferenceStyle constants. |
xlA1 |
xlR1C1 |
expression.ReferenceStyle
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example displays the current reference style.
If Application.ReferenceStyle = xlR1C1 Then
MsgBox ("Microsoft Excel is using R1C1 references")
Else
MsgBox ("Microsoft Excel is using A1 references")
End If