I have a spreadsheet that in column 'C' there are times when the word
PENDING is in the cell instead of a date. I would like to have a macro
that looks at each of these cell in COlumn 'C' and removes the entire row if
the word PENDING in that cell.


Thanks in advance