R1C1 Notation???

[Clueless]

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???

 

[Dave Peterson]

That doesn't look like a valid formula to me.

I bet you meant:

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

But I can refer to EF25 by using:
R25C136

So try:

Range("ED37").FormulaR1C1 = "=-(RC[-118]*R25C136)"

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???