Deleting Rows where multiple words are found

**ScottyZ92** · 10-09-2015, 10:39 AM

Hey All,

I'm running into some trouble creating a macro to delete rows when a word from a blacklist is found. In a column, I have multiple descriptions of items. These descriptions are lengthy and I have "trigger words" that would let me know they are not applicable in the situation. There are multiple trigger words, so I would like to use a blacklist that would look for these trigger words in the description and if it contains any of the words, delete the row. Any help is much appreciated.

Thank you!

EDIT: Column K is the column where descriptions are.
Trigger words are: "studio" "postage" "post it" "label"

**Alf** · 10-09-2015, 10:52 AM

Perhaps having the blacklisted words in an array and then using autofilter to find the rows with blacklisted words and delete them in one go.

Depends a bit on the number of blacklisted word and if there could be more than one column where the words could be found.

Just read your description oh the problem and that should work very well using autofilter.

Alf

**JOHN H. DAVIS** · 10-09-2015, 11:02 AM

Maybe:

Please Login or Register  to view this content.

**ScottyZ92** · 10-09-2015, 11:24 AM

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

Would that work for plurals of words as well, i.e. "labels?" And this searches the entire string of text in the cell for these words, correct? Sorry, just very new to VBA.

**JOHN H. DAVIS** · 10-09-2015, 11:38 AM

Should work for plurals. And yes if a string in Column K contains the word or plural it should delete the entirerow.

**ScottyZ92** · 10-09-2015, 11:48 AM

Originally Posted by JOHN H. DAVIS

Should work for plurals. And yes if a string in Column K contains the word or plural it should delete the entirerow.

It doesn't seem to be removing plurals or words that are all caps or start with a capital. Any ideas on how to fix this?

**JOHN H. DAVIS** · 10-09-2015, 12:22 PM

Try adding Option Compare Text above the code

Please Login or Register  to view this content.

**ScottyZ92** · 10-09-2015, 12:46 PM

Originally Posted by JOHN H. DAVIS

Try adding Option Compare Text above the code

Please Login or Register  to view this content.

Worked like a charm! You're the man!

**JOHN H. DAVIS** · 10-09-2015, 01:21 PM

Glad to hear it worked for you. And thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED. See link below for guidance.

http://www.excelforum.com/forum-rule...rum-rules.html

Deleting Rows where multiple words are found

LinkBack

Thread Tools

Rate This Thread

Display

Deleting Rows where multiple words are found

Re: Deleting Rows where multiple words are found

Re: Deleting Rows where multiple words are found

Re: Deleting Rows where multiple words are found

Re: Deleting Rows where multiple words are found

Re: Deleting Rows where multiple words are found

Re: Deleting Rows where multiple words are found

Re: Deleting Rows where multiple words are found

Re: Deleting Rows where multiple words are found

Thread Information

Users Browsing this Thread

Similar Threads

how can i copy/paste the word which is found during search in the current row wise

Having an issue deleting rows based on certain text found in them...

Macro to delete multiple rows below that that is found

Macro - deleting rows if no image found on server

Using "Find" to return results if a word is found within multiple words in a cell

How to delete multiple rows without deleting the hidden rows when filtered?

Deleting multiple similar words...?

Bookmarks

Bookmarks

Posting Permissions