Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / GetDynamicArrayRange Method
The row index of the cell which belong to the dynamic array.
The column index of the cell which belong to the dynamic array.
true if the cell must be the dynamic array anchor cell.


In This Topic
GetDynamicArrayRange Method
In This Topic
Gets the dynamic array cell range.
Syntax
'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)

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.
See Also

Reference

Worksheet Class
Worksheet Members

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page