Application.ReferenceStyle Property (Excel)
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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:
© 2016 Microsoft