VBA - putting a formula in cells but its got a syntax error please help!! :-)

Hi

I have a formula I want to put in a range of cells but it won't let me - what have I done wrong? It says theres an error on the " Total" part? why?


Range("m2:m" & Cells(Rows.Count, "A").End(xlUp).Row).Formula = "=IF(G6=(G5 & " Total"),IF(K6>$AJ6,"Qualifies","Not Met"),"")"

Its driving me mad!! please help me

thanks

Laura

You must escape quotation marks in the formula string by doubling them:

Please Login or Register  to view this content.

I thought it had something to do with the " but didn't know what to do.

thank you so much this works great :-) another thing learnt today!