Spread WPF 18
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.


In This Topic
    Address(Boolean,Boolean,ReferenceStyle,Boolean,IRange) Method
    In This Topic
    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