I have the following code in my VB:

Range("ED37").Select
ActiveCell.FormulaR1C1 = _
"=-(RC[-118]*R-12C2)"

My next procedure in the macro drags the formula down the range of cells,
however I want R-12C2 to reference the same cell [EF25] as it is dragged down.

Is there a code to do such a task???