Expand Minimize

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.

expression .ReferenceStyle

expression A variable that represents an Application object.

XlReferenceStyle can be one of these XlReferenceStyle constants.

xlA1

xlR1C1

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
Show:
© 2015 Microsoft