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


GrapeCity.Spreadsheet Assembly > GrapeCity.Spreadsheet Namespace > IRange Interface > Address Method : Address(Boolean,Boolean,ReferenceStyle,Boolean,CellReference) 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( _
   ByVal rowAbsolute As Boolean, _
   ByVal columnAbsolute As Boolean, _
   ByVal refStyle As ReferenceStyle, _
   ByVal external As Boolean, _
   ByVal relativeTo As CellReference _
) 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 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