Simple formula not working

[deduwa]

I am getting #NAME ? when executing the below code. Cell F5 in the Manual tab has a number in it so expecting the output to also be a number.

Cells(lastRow + 11, "R").Formula = "=R[-1]C/(Manual!F5)"

I get #NAME ? and when I press F2 on this erroneous cell it shows =R253/Manual!'F5'

I am not sure the ' around the F5 looks correct either.

Can anyone help

Thanks

 

[Eric W]

You're mixing the RC type reference with the A1 type reference in the same formula. Try:

Cells(lastRow + 11, "R").Formula = "=R[-1]C/(Manual!R5C6)"