Range.Formula (Excel)

Returns or sets a Variant value that represents the string's implicitly intersecting formula in A1-style notation.

In Dynamic Arrays enabled Excel, Range.Formula2 supercedes Range.Formula. Range.Formula will continue to be supported to maintain backcompatibility. A discussion on Dynamic Arrays and Range.Formula2 can be found here.

Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10"