Application.ReferenceStyle Property (Excel)
Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write XlReferenceStyle.
Syntax
expression .ReferenceStyle
expression A variable that represents an Application object.
Remarks
XlReferenceStyle can be one of these XlReferenceStyle constants. |
xlA1 |
xlR1C1 |
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