(I posted this previously to the "General" newsgroup in
error)


I'm trying to add a formula in a cell which will leave
the cell blank if column A is blank. I use the following:

ActiveCell.FormulaR1C1 = "=if(+RC[-10]0,2.5,"")"


but I get a run-time error (1004). I know the problem is
the quotes in the third argument. I tried replacing the
quotes with zero and it enters zero correctly with no
error. But I need the cell to be blank, not zero, if
column A is blank.
..