Skip to content

Latest commit

 

History

History
48 lines (29 loc) · 1.09 KB

Excel.Range.FormulaArray.md

File metadata and controls

48 lines (29 loc) · 1.09 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Range.FormulaArray property (Excel)
vbaxl10.chm144133
vbaxl10.chm144133
Excel.Range.FormulaArray
a0c8bafb-294c-32ff-0591-1a798aebb4b4
05/10/2019
medium

Range.FormulaArray property (Excel)

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.

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.

Worksheets("Sheet1").Range("A1:C5").FormulaArray = "=3"

This example enters the array formula =SUM(A1:C3) in cells E1:E3 on Sheet1.

Worksheets("Sheet1").Range("E1:E3").FormulaArray = _ 
 "=Sum(A1:C3)"

[!includeSupport and feedback]