Question: how to create a dynamic formula in excel vba?
Answer: Sheets("Monthly Snapshot").Select.
Range("L7").Select.
ActiveCell.FormulaR1C1 = _
=CONCATENATE("=SUM(I$5:I",(Control! R21C3+4), ")/SUM(H$5:H",(Control! R21C3+4), ")-1")
Range("L7").Select.
Selection.Copy.
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False.