Hi

I have the following code in VBA

MyFormula = "=IF(E10="""";F9;F9+E10)"
Range(Cells(Row + 2, 5), Cells(Row + 2, 5).Value = MyFormula

When executed I get Run-time error '1004'
Application-defined or object-defined error

If I change MyFormula to "=F8+F9" then it works OK.

MyFormula is created in the VBA routine.

Can it be done ??

Thanks in advanced for any help.

Tage