Set array formula to a range of cells
Syntax
'Declaration
Sub SetArrayFormula( _
ByVal As Integer, _
ByVal As Integer, _
ByVal As Integer, _
ByVal columnFirst As Short, _
ByVal columnLast As Short, _
ByVal As IExcelFormula _
)
'Usage
Dim instance As IExcelReader
Dim sheet As Integer
Dim rowFirst As Integer
Dim rowLast As Integer
Dim columnFirst As Short
Dim columnLast As Short
Dim arrayFormula As IExcelFormula
instance.SetArrayFormula(sheet, rowFirst, rowLast, columnFirst, columnLast, arrayFormula)
Parameters
- sheet
- The zero based sheet index used to locate the IExcelWorksheet instance
- rowFirst
- The zero based inclusive top left cell row index
- rowLast
- The zero based inclusive bottom right cell row index
- columnFirst
- The zero based inclusive top left cell column index
- columnLast
- The zero based inclusive top left cell column index
- arrayFormula
- The array formula for these cell
Exceptions
See Also