To place a formula in a cell using Excel VBA, use the following code:
Sub VBAFormula()
Range(“A3”).Value = “=AVERAGE(A1:A2)”
End Sub
Excel Hack 28: Use macros to put formulas in cells
