Quotation marks in a function causing an error?

I have a macro that contains the following line:

ActiveCell.FormulaR1C1 = "=TEXT(RC[-1],"DDDD")"

but it seems that the debugger is counting the second quotation mark (just before the DDDD) as the end of the TEXT function, and it's giving me an "Expected: End of Statement" error. How do I get around this?

Thanks

You need one more set of quotes in this situation:

Please Login or Register  to view this content.

That's something I would never had though of.

Thanks for your help!