ExcelSetArrayFormula Method
ARRAY - Excel Biff Record
'Declaration
Function ExcelSetArrayFormula( _
ByVal As Integer, _
ByVal As Integer, _
ByVal As Integer, _
ByVal As Short, _
ByVal As Short, _
ByVal () As Byte, _
ByVal () As Byte _
) As Boolean
'Usage
Dim instance As IExcelBiffRead
Dim sheet As Integer
Dim rowFirst As Integer
Dim rowLast As Integer
Dim colFirst As Short
Dim colLast As Short
Dim formula() As Byte
Dim extra() As Byte
Dim value As Boolean
value = instance.ExcelSetArrayFormula(sheet, rowFirst, rowLast, colFirst, colLast, formula, extra)
Parameters
- sheet
- Sheet index
- rowFirst
- rowLast
- colFirst
- colLast
- formula
- extra