Variable in an R1C1 formula

[kptheop]

I am trying to put the following into a cell:

cell(2,3) = "R[-1]c*J"

(where j has been previously defined in the macro)

But, I get an error message "application defined or object define
error"

Any suggestions?

Thanks. :

 

[Frank Kabel]

Hi
try
cells(2,3).formulaR1C1 = "=R[-1]C*" & J