Skip to content

Latest commit

 

History

History
48 lines (30 loc) · 1.03 KB

Excel.Application.ReferenceStyle.md

File metadata and controls

48 lines (30 loc) · 1.03 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.ReferenceStyle property (Excel)
vbaxl10.chm133197
vbaxl10.chm133197
Excel.Application.ReferenceStyle
86c4931b-ab1a-0363-d048-5195707a952b
04/05/2019
medium

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

[!includeSupport and feedback]