Formula with quotations - expected end of statement

[meghan.k]

Hi,

I am trying to put the following line of code into a macro to pull information from a pivot table created by the macro. When I type in the formula I get an error saying "expected end of statement". I would imagine this is due to the quotation marks. How can I get around this?

ActiveCell.FOrmulaR1C1 = "=GETPIVOTDATA("Amount",Table!$A$1,"Card Type","AMEX","Batch Date",'Journal Template'!$A$7)"

Thanks!