Delete all rows with the data "06 - DEAD" in column H

**nabeelmn** · 01-06-2008, 09:33 AM

Can Someone help me out with a macro.

I need a macro to delete all rows with the data "06 - DEAD" in column H

Would really appreciate if someone could help me out with this.

**VBA Noob** · 01-06-2008, 09:40 AM

Try

Please Login or Register  to view this content.

VBA Noob

**VBA Noob** · 01-06-2008, 10:01 AM

Or Royuk likes using the below union method

Please Login or Register  to view this content.

VBA Noob

**royUK** · 01-06-2008, 11:04 AM

Hi Noob

Your code should be pretty quick so long as the data is in a filterable format.

**nabeelmn** · 01-07-2008, 12:24 AM

Thanks a lot!!!!

Delete all rows with the data "06 - DEAD" in column H

LinkBack

Thread Tools

Rate This Thread

Display

Delete all rows with the data "06 - DEAD" in column H

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions