Formula Not Working-Help Please!!!
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.....
|