Variables with ActiveCell.FormulaR1C1

[davidam]

Hello Everyone,
Can someone tell me why this fails at the ActiveCell.Formula line?

Dim RowForm As Integer
Dim ColForm As Integer
RowForm = 39
ColForm = -2
    ActiveCell.FormulaR1C1 = "=R[RowForm]C[ColForm]"

Many thanks,
David

 

[njimack]

Surely it would be
ActiveCell.FormulaR1C1 = "=R[" & RowForm & "]C[" & ColForm & "]"

 

[davidam]

Yes...of course! Works perfect. Thanks

 

[njimack]

Glad to help, thanks for the feedback.