Share via


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

See Also

Concepts

Application Object

Application Object Members