Range.Formula

[heffo500]

Hi

I am having issue with me code below it inserts the code into all the cells except cell U2, Can anybody tell me where I am going wrong?

Range("R2").Formula = "=IF(AND(A3=""Subtotal"",LEN(C3)=3,H3<>0),INDEX(Sheet2!E:E,MATCH(1,INDEX((G3=Sheet2!B:B)*(K3=Sheet2!C:C),0),0)),"""")"
Range("S2").Formula = "=IF(R2="""","""",-H3*R2)"
Range("T2").Formula = "=IF(R2="""","""",L3-S2)"
Range("U2").Formula = "=IF(LEN(C2)=2,SUMIFS(T:T,B:B,C2),"")"
Range("V2").Formula = "=IF(U2="""","""",U2/L2)"
Range("W2").Formula = "=IF(V2="""","""",IF(ABS(V2)>0.035,""YES"",""NO""))"
Range("X2").Formula = "=IF(V2="""","""",INDEX(Sheet4!M:M,MATCH(1,INDEX((""585031 "" & C2=Sheet4!B:B)*(ISNUMBER(Sheet4!L:L)),0),0)))"
Range("Y2").Formula = "=IF(V2="""","""",IF(W2=X2,""OK"",""BREAK""))"
Range("R2:Y2").Copy
Range("R3:Y" & lr).PasteSpecial

Thanks

 

[RoryA]

You didn't double up the quotes in the formula:

Range("U2").Formula = "=IF(LEN(C2)=2,SUMIFS(T:T,B:B,C2),"""")"

 

[steve the fish]

If you look at every other formula you use """". In that one you just have "". You have to use """".