View Single Post
 
Old 03-19-2017, 12:12 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

The URL link you provided shows how to search for ONE WORD at a time, in a specified area/range of the worksheet and delete the row that contains that word. My first post does the same thing.

My first post: deletes all rows containing the word you are searching for.

My second post: deletes all rows EXCEPT those that contain the word you are searching for.

The URL link http://stackoverflow.com/questions/1...fined-in-range will search multiple words at the same time and delete any row that contains any of those words.

Either you don't understand how the macro works ... or you are not clearly explaining what it is you are seeking.

In either case, you now have access to three different methods:

You have already been given several examples that will do what you need. You only need to choose one.