Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IRange Interface / Address Method / Address(Boolean,Boolean,ReferenceStyle,Boolean,CellReference,Boolean) 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.
true to exlucde the workbook name; otherwise, false to include the workbook name.


In This Topic
    Address(Boolean,Boolean,ReferenceStyle,Boolean,CellReference,Boolean) Method
    In This Topic
    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, _
       Optional ByVal skipWorkbook 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 rowAbsolute and columnAbsolute are false and the refStyle 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.
    Remarks
    If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and columns.
    See Also