FormulaArray Property

Microsoft Office Web Components Visual Basic

previous page next page

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)"
previous page start next page