Hi Matthias,

The quotation marks inside you IF formula need to be doubled, i.e.

Change: "=wenn(xy;"ja";"nein")"

to: "=wenn(xy,""ja"",""nein"")"


Of course this IF formula will return an error unless xy represents a
logical condition which the worksheet can evaluate.


---
Regards,
Norman



"Matthias Frohnapfel" wrote in message
...
Hello,

I've a VBA Macro. This should write a formular like

"=wenn(xy;"ja";"nein")"

in a cell. I tried this: Range("B9").value = "=wenn(xy;"ja";"nein")"

I think there is also a problem with executing this formular. Can
somebody
help me, please?

Thank you!