Problem inserting a function from VBA

[tagen]

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

[antoka05]

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

it seems good

[Bryan Hessey]

Perhaps

=IF(ISBLANK(E9),E10,E9+E10)

might serve your purposes better than what I presume you meant to be

=IF(E10="",F9,F9+E10)


the ; appear to be the source of your error.

---

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

[tagen]

You're right antoka05, changing the ; to , did the trick.
I used the ; because when entering the IF function in the spreadsheet I have to used ; - , is used for decimal-point and I just looked at the syntax in the spreadsheet.

Thanks for quick answer.