formula?
 

(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.
..

formula?
 

Pam,

Try something like

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"pam" wrote in message
...

(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.
.