ReferenceStyle Property [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | Application Object