'Declaration Overloads Function Address( _ Optional ByVal rowAbsolute As Boolean, _ Optional ByVal columnAbsolute As Boolean, _ Optional ByVal refStyle As ReferenceStyle, _ Optional ByVal external As Boolean, _ Optional ByVal relativeTo As IRange _ ) 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 IRange Dim value As String value = instance.Address(rowAbsolute, columnAbsolute, refStyle, external, relativeTo)
string Address( bool rowAbsolute, bool columnAbsolute, ReferenceStyle refStyle, bool external, IRange relativeTo )
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.
Return Value
A System.String value represents the range reference.