AutoFilter the word PENDING, then select all the PENDING rows, go to Edit
Delete Rows

"Johnfli" wrote:

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