'Declaration
Overloads Function Address( _ ByVal rowAbsolute As Boolean, _ ByVal columnAbsolute As Boolean, _ ByVal refStyle As ReferenceStyle, _ ByVal external As Boolean, _ ByVal relativeTo As CellReference, _ ByVal skipWorkbook As Boolean _ ) As String
'Usage
Dim instance As IRange Dim rowAbsolute As Boolean Dim columnAbsolute As Boolean Dim refStyle As ReferenceStyle Dim external As Boolean Dim relativeTo As CellReference Dim skipWorkbook As Boolean Dim value As String value = instance.Address(rowAbsolute, columnAbsolute, refStyle, external, relativeTo, skipWorkbook)
string Address( bool rowAbsolute, bool columnAbsolute, ReferenceStyle refStyle, bool external, CellReference relativeTo, bool skipWorkbook )
Parameters
- rowAbsolute
true
to return the row part of the reference as an absolute reference.- columnAbsolute
true
to return the column part of the reference as an absolute reference.- refStyle
- A ReferenceStyle value indicates the reference style.
- external
true
to return the external reference; otherwise,false
to return local reference.- relativeTo
- The starting point for the relative reference if rowAbsolute and columnAbsolute are
false
and the refStyle is ReferenceStyle.R1C1. - skipWorkbook
true
to exlucde the workbook name; otherwise,false
to include the workbook name.
Return Value
A System.String value represents the range reference.