Delete rows that do no contain a specific word

**Tesseh** · 11-12-2013, 01:25 AM

Hi,

I'm trying to write a macro that deletes a row if column B does not contain the word "DOGS"

There is a different number of rows every day.

Any help would be greatly appreciated,

Thanks!

**Trebor76** · 11-12-2013, 01:49 AM

Hi Tesseh (and fellow Sydneyite

),

Try this (initially on a copy of your data as results cannot be undone if they're not as expected):

Please Login or Register  to view this content.

Note that the code is looking for the text 'DOGS' in that case. If your not worried about case sensitivity (i.e. 'Dogs', 'dogs', etc...), change this line of code...

Please Login or Register  to view this content.

...to this:

Please Login or Register  to view this content.

Regards,

Robert

**Tesseh** · 12-15-2014, 01:43 AM

Robert, did I ever thank you for this? I use this macro everyday and it works perfectly. Thanks so much!!!!

**Trebor76** · 12-15-2014, 02:08 AM

No, I didn't think you ever did but that's fine - you have now

If you could mark the thread as closed it would be appreciated.

Thanks,

Robert

Delete rows that do no contain a specific word

LinkBack

Thread Tools

Rate This Thread

Display

Delete rows that do no contain a specific word

Re: Delete rows that do no contain a specific word

Re: Delete rows that do no contain a specific word

Re: Delete rows that do no contain a specific word

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] delete rows when column has specific word(s)

[SOLVED] Macro to delete rows that DO NOT contain specific word

[SOLVED] Need a macro to delete rows with specific word

Delete all rows that dont contain a specific word.

Macro to look for a specific word and delete rows

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions