expression.FormulaArray
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)"