Excel Macro - FormulaR1C1 1

[Casbah]

ActiveCell.FormulaR1C1 = "=((RC[-1])/R19C2)*100"

What I want to do is change this formula so that the "R19" isnt hard coded. I already have a variable called rowsnum which contains the value i want to use instead.

ActiveCell.FormulaR1C1 = "=((RC[-1])/R[rowsnum]C2)*100"
wont work for me, is it possible to do what I want and if so where am I going wrong?

 

[Molby]

Try:
ActiveCell.FormulaR1C1 = "=((RC[-1])/R" & rowsnum & "C2)*100

 

[Casbah]

Sweet, thanks