-->
Returns or sets 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 null. Read/write Variant.
Microsoft just announced a new feature for Excel that will change the way we work with formulas. The new dynamic array formulas allow us to return multiple results to a range of cells based on one formula. This is called the spill range, and I explain more about it below. Excel currently has 7 new dynamic array functions, with more on the way. Array formulas can return either multiple results, or a single result. Beginning with the September 2018 update for Microsoft 365, any formula that can return multiple results will automatically spill them either down, or across into neighboring cells. This change in behavior is also accompanied by several new dynamic array functions. If the value was a range, then pick the cell on the same row or column as the formula; If the value was an array, then pick the top left value; With the advent of dynamic arrays, Excel is no longer limited to returning single values from formulas, so invisible implicit intersection is no longer needed. Where an old Excel formula could invisibly.
Syntax
expression.FormulaArray
expression A variable that represents a Range object.
Remarks
The FormulaArray property also has a character limit of 255.
Example
This example enters the number 3 as an array constant in cells A1:C5 on Sheet1.
Array Formula Problem Microsoft Excel Example
This example enters the array formula =SUM(A1:C3) in cells E1:E3 on Sheet1.
Support and feedback
Array Formula Problem Microsoft Excel Download
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.