getting this error "compile error: Expected: end of statement”

[steve400243]

Hello, Anyone know why I would be getting this error with this code? Any help would be greatly appreciated.

FR = MyRegions.Areas(1).Cells(1).Row
    .Range("M" & FR & ":P" & lr).SpecialCells(xlBlanks).Formula = "=IF(Q3="FMM",NETWORKDAYS.INTL(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3,"1000011"),NETWORKDAYS(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3,Sheet2!$B$2:$B$7))-1"
    End With

 

[Fluff]

You need to double-up all the quotes inside the formula

 

[steve400243]

You need to double-up all the quotes inside the formula

Thanks Fluff - I guess I'm not seeing where quotes are missing? I tried here, but still get the same message.

"=IF"(Q3="FMM",

 

[steve400243]

You need to double-up all the quotes inside the formula

Never mind Fluff - I see what you mean. Not enough coffee yet!! Thank you again.

 

[Fluff]

Glad you sorted it & thanks for the feedback