Applies To
Range Object.
Description
Returns or sets the formula of a range, entered as an array. Returns (or can be set to) a single formula or a Visual Basic array. If the specified range is not array-entered, this property returns Null. Read-write.
Remarks
If you use this property to array-enter a formula, the formula must use the R1C1 reference style, not the A1 reference style; see the second example.
See Also
Formula Property.
Example
This example enters the number 3 as an array constant in cells A1:C5 on Sheet1.
Worksheets("Sheet1").Range("A1:C5").FormulaArray = "=3"
This example array-enters the formula =SUM(R1C1:R3C3) in cells E1:E3 on Sheet1.
Worksheets("Sheet1").Range("E1:E3").FormulaArray = _
"=Sum(R1C1:R3C3)"