Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/getting-s...
Adding a formula in to a cell in Excel is fairly easy in this video you will see how to send a formula to a cell using the standard formula notation and the R1C1 notation
Code
==================
Sub AddFormula()
Range("B10") = "=Sum(A9:A15)"
Range("B11") = "=Sum(R[-2]C[-1]:R[9]C[-1])"
End Sub