thanks logit, i found that same code from extendoffice, but that doesn't really work for me, since i have multiple words/phrases that i need to use as my criteria. that code seems to be ok if you only have one word to use as a criteria. i'm looking for something more like this, but for rows instead of cells:

https://www.thespreadsheetguru.com/t...word-or-phrase