Gets or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style.

[Visual Basic]
Property ReferenceStyle As XlReferenceStyle
[C#]
XlReferenceStyle ReferenceStyle { get; set; }
[C++]
__property XlReferenceStyle get_ReferenceStyle();
__property void set_ReferenceStyle(XlReferenceStyle );
[JScript]
function get ReferenceStyle() : XlReferenceStyle
function set ReferenceStyle(XlReferenceStyle);

Property Value

One of the XlReferenceStyle values.

Example

This example sets R1C1 reference style for a workbook.

[C#]
book.ReferenceStyle = XlReferenceStyle.xlR1C1;

[Visual Basic]
book.ReferenceStyle = XlReferenceStyle.xlR1C1

[C++]
book->ReferenceStyle = XlReferenceStyle::xlR1C1;

See Also

IWorkbook Interface | NativeExcel Namespace | XlReferenceStyle Enumeration

---