Locate column with specific title and delete rows if predefined set of text is found

Hi, mazrientes,

welcome to ExcelForum. Please note that according to Rule #2 you should start your own thread with your question.

I´d rely on the Autofilter for this kind of problem (use "contains" for the item you search for) instead of a loop with wildcards. And if you want a loop alter the parameter from lookat:=xlWhole to lookat:=xlPart.

Ciao,
Holger