GetDynamicArrayRange Method

In This Topic

Gets the dynamic array cell range.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetDynamicArrayRange( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   Optional ByVal direct As Boolean _
) As Reference

'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim direct As Boolean
Dim value As Reference
 
value = instance.GetDynamicArrayRange(row, column, direct)

public Reference GetDynamicArrayRange( 
   int row,
   int column,
   bool direct
)

Parameters

row: The row index of the cell which belong to the dynamic array.
column: The column index of the cell which belong to the dynamic array.
direct: true if the cell must be the dynamic array anchor cell.

Return Value

A Reference value represents the cell range of the dynamic array. Negative column represents the dynamic array has #SPILL error. Reference.Empty if the cell doesn't belong to the dynamic array.

Reference

Worksheet Class
Worksheet Members

Product Support Forum | Print this page