Hi,

I am using the following R1C1 formulas to enter a formula into a given cell.
This works.

However, I need to use an if then statement within it an for some reason I am unable to do so.

It should say : Formula R1C1 = "if(isblank(RC[1]),"",+RC[1]&"" ""&ROW()"

Can someone help make this work please??

.FormulaR1C1 = "=+RC[1]&"" ""&ROW()" '
 .Cells(7).Offset(2, 0).FormulaR1C1 = "=+R[-1]C[1]&"" ""&ROW()"