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

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

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

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.

painting

true if the formula will be evaluated if cell is dirty.

Return Value

Reference

Worksheet Class
Worksheet Members