Selection.Formula = "=SUMIF(I12:I50030,""<MES"",T12:T50030)"

HTH
--
AP


"Paige" a écrit dans le message de news:
...
Can someone tell me what is wrong with this code? I get an
application/object defined error on the 2nd row. Am trying to insert a
sumif
formula into a cell, to add only those cells that do NOT have the word
"MES"
in them.

Cells(Cells.Rows.Count, "T").End(xlUp).Offset(-1, 0).Select
Selection.Formula = "=SUMIF(I12:I50030,< ""MES"",T12:T50030)"

Thanks.....