Collapse the table of content
Expand the table of content
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

Range.Address Property

Returns the range reference.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

string this[
	Object RowAbsolute,
	Object ColumnAbsolute,
	XlReferenceStyle ReferenceStyle,
	Object External,
	Object RelativeTo
] { get; }

Parameters

RowAbsolute
Type: System.Object

Optional Object. True to return the row part of the reference as an absolute reference. The default value is True.

ColumnAbsolute
Type: System.Object

Optional Object. True to return the column part of the reference as an absolute reference. The default value is True.

ReferenceStyle
Type: Microsoft.Office.Interop.Excel.XlReferenceStyle

Optional XlReferenceStyle.

External
Type: System.Object

Optional Object. True to return an external reference; False to return a local reference. The default value is False.

RelativeTo
Type: System.Object

Optional Object. If RowAbsolute and ColumnAbsolute are False, and ReferenceStyle is xlR1C1, you must include a starting point for the relative reference. This argument is a Range object that defines the starting point.

Property Value

Type: System.String

If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and columns.

Show:
© 2016 Microsoft