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