Range.FormulaArray (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.

The FormulaArray property also has a character limit of 255.

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