VBA Will Not allow me to enter this formula as shown below.

[ebrandt]

VBA Will Not allow me to enter this formula as shown below............

ActiveCell.FormulaR1C1 = "=(GETPIVOTDATA("Total",'TKOFF Summary'!$A$3,"LEVEL 3","D" & Select_Row,"Area",F7,"CSI MF CODE","H" & Select_Row,"ITEM DESCRIPTION","I" & Select_Row,"Unit","K" & Select_Row7"

I keep getting the message "Compile Error: Expected end of statement" and the word “Total” is hi-lighted. How do I fix this?

 

[mole999]

what was the rest of the formula

 

[ebrandt]

Here is the complete line of VBA Code.

ActiveCell.FormulaR1C1 = "=IFERROR(GETPIVOTDATA("Total",'TKOFF Summary'!$A$3,"LEVEL 3","D" & Select_Row,"Area","F" & Select_Row,"CSI MF CODE","H" & Select_Row,"ITEM DESCRIPTION","I" & Select_Row,"Unit","K" & Select_Row),0)