delete rows when column has specific word(s)

So you need to find all cells with the word "ABC" in column "B" and if its found then delete the whole row. Correct?

Thanks

Try this is a copy of your workbook. Data will be delete and It cannot be undone.

Please Login or Register  to view this content.

Thanks

My apologies and will do in the future

Originally Posted by alansidman

Chris - Welcome to the forum, however........

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added the code tags for you. Please comply with our rules in the future)

Thanks Fredlo2010

didn't work but also no error

Thanks again

Originally Posted by chrisblackman

didn't work but also no error

It works for me. Most likely its just a reference issue. Can you attach a small sample of your workbook?

Thanks

The code you have works too, but need few tweaking.

Please Login or Register  to view this content.

Thanks for your help but I am unable to post attachment
I'm following instructions but don't see where to attach


I'm sorry

Did you try post # 8?

Thanks a million

here is attachment
I am trying to delete rows where column H has certain word say "longmeadow"
or any word specific word that I need rows removed

I did and nothing happened

Originally Posted by AB33

Did you try post # 8?

hi, chrisblackman, option, please check attachment, run code "test" or press Run button

This one works and deletes

Please Login or Register  to view this content.

Try the attached.
The code was initially written for a loop code ,hence you see lots of commenting on some of the lines.

Here is a variant you can also try.

Please Login or Register  to view this content.

Thanks

AB33 Thanks very much!!! it works

Originally Posted by AB33

Try the attached.
The code was initially written for a loop code ,hence you see lots of commenting on some of the lines.

Fredlo2010 Thanks so very much it works also

You are welcome