vba macro to remove rows if different from specific cell

**Hyflex** · 10-06-2011, 01:08 PM

Macro to remove all rows if different from B2...

I have tried a number of ways but nothing is working, here are two of the macros Ive messed around with.

It's supposed to look in B2 and then any of the rows below (B3, B4, B5, B6....etc) are different then it is supposed to delete entire row

Please Login or Register  to view this content.

**tigeravatar** · 10-06-2011, 01:17 PM

Hyflex,

Something like this?

Please Login or Register  to view this content.

**Hyflex** · 10-06-2011, 01:25 PM

Your macro, deletes all rows apart from B2... I need it to keep some

Basically B2 down to B9 consists of:

Please Login or Register  to view this content.

Any Cell in B what do NOT = B2 (06/10/2011) should be delete (in this case the last 3 rows)

**tigeravatar** · 10-06-2011, 01:28 PM

Hyflex,

Same macro, ran test with provided criteria, kept all 6/10/2011 rows, attached is sample workbook...

vba macro to remove rows if different from specific cell

LinkBack

Thread Tools

Rate This Thread

Display

vba macro to remove rows if different from specific cell

Re: vba macro to remove rows if different from specific cell

Re: vba macro to remove rows if different from specific cell

Re: vba macro to remove rows if different from specific cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions