removing rows featuring certain words (wildcards needed)

[joe14]

Hi, Im new to Excel, hope you can help me out, I've got this macro:

Please Login or Register  to view this content.

But it works only for rows with "EXTRA" word in them.

I need it work also with e.g. "EXTRA_A" "EXTRA_B" "TT_EXTRA" etc. so I guess best would be use wildcard for EXTRA -> "*EXTRA*" but it doesnt work.

Any solutions to this?
Thanks a lot.

[LiamPotter]

Please Login or Register  to view this content.

As per the page I found the code from you could set the value you search for and delete any row containing by using an InputBox (so you could delete any rows containing text you specify without having to edit the code):

Please Login or Register  to view this content.

I know it's probably not what you're looking for but the easiest to work out way around your problem. I take no credit for this code, a simple bit of googling found it!

~Liam