ReferenceStyle Property
From Microsoft Excel Visual Basic
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