Spread Windows Forms 12.0 Product Documentation
Address(Boolean,Boolean,ReferenceStyle,Boolean,IRange) Method


GrapeCity.Spreadsheet Assembly > GrapeCity.Spreadsheet Namespace > IRange Interface > Address Method : Address(Boolean,Boolean,ReferenceStyle,Boolean,IRange) Method
true to return the row part of the reference as an absolute reference.
true to return the column part of the reference as an absolute reference.
A ReferenceStyle value indicates the reference style.
true to return the external reference; otherwise, false to return local reference.
The starting point for the relative reference if rowAbsolute and columnAbsolute are false and the refStyle is ReferenceStyle.R1C1.
Returns a System.String value that represents the range reference.
Syntax
'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)

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.
Remarks
If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and columns.
See Also

Reference

IRange Interface
IRange Members
Overload List