Application.ReferenceStyle Property

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.

Visual Basic for Applications
`If Application.ReferenceStyle = xlR1C1 Then MsgBox ("Microsoft Excel is using R1C1 references") Else MsgBox ("Microsoft Excel is using A1 references") End If`

Reference reference style referencestyle referencestyle property

Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write XlReferenceStyle.