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