Edit

Share via

Application.ReferenceStyle property (Excel)

  • Article

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 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.