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