Address(Boolean,Boolean,ReferenceStyle,Boolean,CellReference,Boolean) Method
Returns a
System.String value that represents the range reference.
'Declaration
Overloads Function Address( _
ByVal As Boolean, _
ByVal columnAbsolute As Boolean, _
ByVal As ReferenceStyle, _
ByVal As Boolean, _
ByVal As CellReference, _
Optional ByVal 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)
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 and columnAbsolute are
false
and the 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.