Syntax Error in Coded Formula

[Ark68]

There is a syntax error in my code below. The formula works within the cell but when coded, gives me an error.

    Range("K2:K8600").Formula = "=IF(ISNA(VLOOKUP(CONCATENATE(C2,D2),FACILITIES!$A$1:$B$100,2,FALSE)),"Empty",VLOOKUP(CONCATENATE(C2,D2),FACILITIES!$A$1:$B$100,2,FALSE))"

Jenn

 

[xld]

Range("K2:K8600").Formula = "=IF(ISNA(VLOOKUP(CONCATENATE(C2,D2),FACILITIES!$A$1:$B$100,2,FALSE))," & _
                            """Empty"",VLOOKUP(CONCATENATE(C2,D2),FACILITIES!$A$1:$B$100,2,FALSE))"