Export (0) Print
Expand All
Expand Minimize

Application.ReferenceStyle Property

Office 2007
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.

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



Community Additions

ADD
Show:
© 2014 Microsoft