FormulaArray Property

Returns or sets a Variant representing the array formula of a range. Returns (or can be set to) a single formula or a Visual Basic array. If the specified range doesn't contain an array formula, this property returns a null string (""). Read/write.

expression   Required. An expression that returns a Range object.

Example

This example enters the array formula =SUM(A1:A3) in cells E1:E3 on the active worksheet.

Spreadsheet1.ActiveSheet.Range("E1:E3").FormulaArray = _
         "=SUM(A1:A3)"