Address Method

Address(bool, bool, ReferenceStyle, bool, CellReference, bool)

Returns a string value that represents the range reference.

Declaration

string Address(bool rowAbsolute, bool columnAbsolute, ReferenceStyle refStyle, bool external, CellReference relativeTo, bool skipWorkbook = false)

Function Address(rowAbsolute As Boolean, columnAbsolute As Boolean, refStyle As ReferenceStyle, external As Boolean, relativeTo As CellReference, Optional skipWorkbook As Boolean = False) As String

Parameters

Type	Name	Description
bool	rowAbsolute	`true` to return the row part of the reference as an absolute reference.
bool	columnAbsolute	`true` to return the column part of the reference as an absolute reference.
ReferenceStyle	refStyle	A ReferenceStyle value indicates the reference style.
bool	external	`true` to return the external reference; otherwise, `false` to return local reference.
CellReference	relativeTo	The starting point for the relative reference if `rowAbsolute` and `columnAbsolute` are `false` and the `refStyle` is R1C1.
bool	skipWorkbook	`true` to exlucde the workbook name; otherwise, `false` to include the workbook name.

Returns

Type	Description
string	A string value represents the range reference.

Remarks

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

Address(bool, bool, ReferenceStyle, bool, string)

Returns a string value that represents the range reference.

Declaration

string Address(bool rowAbsolute, bool columnAbsolute, ReferenceStyle refStyle, bool external, string relativeTo)

Function Address(rowAbsolute As Boolean, columnAbsolute As Boolean, refStyle As ReferenceStyle, external As Boolean, relativeTo As String) As String

Parameters

Type	Name	Description
bool	rowAbsolute	`true` to return the row part of the reference as an absolute reference.
bool	columnAbsolute	`true` to return the column part of the reference as an absolute reference.
ReferenceStyle	refStyle	A ReferenceStyle value indicates the reference style.
bool	external	`true` to return the external reference; otherwise, `false` to return local reference.
string	relativeTo	The starting point for the relative reference if `rowAbsolute` and `columnAbsolute` are `false` and the `refStyle` is R1C1.

Returns

Type	Description
string	A string value represents the range reference.

Remarks

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

Address(bool, bool, ReferenceStyle, bool, IRange)

Returns a string value that represents the range reference.

Declaration

string Address(bool rowAbsolute = true, bool columnAbsolute = true, ReferenceStyle refStyle = ReferenceStyle.A1, bool external = false, IRange relativeTo = null)

Function Address(Optional rowAbsolute As Boolean = True, Optional columnAbsolute As Boolean = True, Optional refStyle As ReferenceStyle = ReferenceStyle.A1, Optional external As Boolean = False, Optional relativeTo As IRange = Nothing) As String

Parameters

Type	Name	Description
bool	rowAbsolute	`true` to return the row part of the reference as an absolute reference.
bool	columnAbsolute	`true` to return the column part of the reference as an absolute reference.
ReferenceStyle	refStyle	A ReferenceStyle value indicates the reference style.
bool	external	`true` to return the external reference; otherwise, `false` to return local reference.
IRange	relativeTo	The starting point for the relative reference if `rowAbsolute` and `columnAbsolute` are `false` and the `refStyle` is R1C1.

Returns

Type	Description
string	A string value represents the range reference.

Remarks

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