Find and Delete

**rkeane7** · 08-11-2008, 06:07 AM

Hi,

i am looking to create a macro that will find a specific word, if the word is found I would like it to delete that row and all rows below it.

I have wrote the following but this only delete the row where the word has been found.

Please Login or Register  to view this content.

Could any1 please help?

Thanks in advance.

**Stuie** · 08-11-2008, 06:18 AM

Hi rkeane7,

I would take a slightly different approach myself.

Give this a try:

Please Login or Register  to view this content.

i havnt been able to test this code but give it a try and if not let me know

**royUK** · 08-11-2008, 07:54 AM

Try this

Please Login or Register  to view this content.

**rkeane7** · 08-11-2008, 10:24 AM

Thanks guys, ill give them a go.

Find and Delete

LinkBack

Thread Tools

Rate This Thread

Display

Find and Delete

Search and Delete

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions