Returns a string representing the specified zero based row and column indexes.
'Declaration
Overloads Function GetAddress( _
ByVal As System.Integer, _
ByVal column1 As System.Integer, _
ByVal As System.Integer, _
ByVal column2 As System.Integer, _
ByVal As System.Integer, _
ByVal columnBase As System.Integer, _
ByVal As System.Boolean, _
ByVal column1Abs As System.Boolean, _
ByVal As System.Boolean, _
ByVal column2Abs As System.Boolean, _
ByVal As System.Boolean, _
ByVal As ReferenceStyle _
) As System.String
'Usage
Dim instance As IWorkbookSet
Dim row1 As System.Integer
Dim column1 As System.Integer
Dim row2 As System.Integer
Dim column2 As System.Integer
Dim rowBase As System.Integer
Dim columnBase As System.Integer
Dim row1Abs As System.Boolean
Dim column1Abs As System.Boolean
Dim row2Abs As System.Boolean
Dim column2Abs As System.Boolean
Dim forceRange As System.Boolean
Dim referenceStyle As ReferenceStyle
Dim value As System.String
value = instance.GetAddress(row1, column1, row2, column2, rowBase, columnBase, row1Abs, column1Abs, row2Abs, column2Abs, forceRange, referenceStyle)
System.string GetAddress(
System.int ,
System.int column1,
System.int ,
System.int column2,
System.int ,
System.int columnBase,
System.bool ,
System.bool column1Abs,
System.bool ,
System.bool column2Abs,
System.bool ,
ReferenceStyle
)
Parameters
- row1
- The first row of the range.
- column1
- The first column of the range.
- row2
- The last row of the range.
- column2
- The last column of the range.
- rowBase
- Specifies the base row for relative references in the R1C1 reference style, ignored for the A1 reference style.
- columnBase
- Specifies the base column for relative references in the R1C1 reference style, ignored for the A1 reference style.
- row1Abs
- Specifies whether the first row is absolute.
- column1Abs
- Specifies whether the first column is absolute.
- row2Abs
- Specifies whether the last row is absolute.
- column2Abs
- Specifies whether the last column is absolute.
- forceRange
- Specifies whether a range reference should be returned for a single cell (row1 == row2 and column1 == column2).
- referenceStyle
- Specifies whether to use the A1 reference style or R1C1 style.
Return Value
The range formatted as a range reference in the specified reference style.
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2