I thought that this was working but it isn't. Is there a way to have more than one ContainWord and only have the sub delete a row if none of the ContainWords are found? I tried editing the sub to add another ContainWord, but it ends up deleting every row on the page. It searches for the first ContainWord and deletes all the rows that don't contain that word, and then it searches for the second ContainWord and deletes all the rows that don't contain that word, leaving me with a blank page. So if I have a spreadsheet and I want to remove all rows that don't contain either the words coffee or cups, can I do this?