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()"
Bookmarks