Range("c4").formula = "=IF(C4 = 5,""ACTIVATED"",""NOT ACTIVATED"")"


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"anon" wrote in message
...
Hi,

I want to put this formula into a cell via VBA;

=IF(C4 = 5,"ACTIVATED","NOT ACTIVATED")

However this would mean the code would be;

range("c4").formula = "=IF(C4 = 5,"ACTIVATED","NOT ACTIVATED")"

which will cause me errors because of the "" enclosed in the formula.
I'd appreciate if anyone could clear this up for me. Thanks,