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.