logit, it doesn't work for me because i have multiple words that i have to test for and having to do a check against one criteria at a time will remove rows i don't want removed. for example, if i want to remove all rows not containing the word 'one,' 'two,' or 'three,' and i run the code the first time against the word 'one,' it will remove all rows that don't contain the word 'one,' but will also remove the rows that contain the words 'two' and 'three,' which are rows i want to keep. i modified the script from the web page i provided earlier to include multiple criteria to check against, but again, that only removes cells, not rows. if that script can be modified to remove rows instead of cells, it would be perfect.