'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)

string Address( 
   bool rowAbsolute,
   bool columnAbsolute,
   ReferenceStyle refStyle,
   bool external,
   CellReference relativeTo,
   bool 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

Reference

IRange Interface
IRange Members
Overload List