How to remove duplicate rows only if columns A and B are BOTH duplicates in Excel 2003

Greetings,

I have a sheet with data in columns A and B. Its approx 2000 rows long. I need to remove the duplicate rows, but only if BOTH columns are duplicated. I need to leave the unique dates for each unit. I need to do it in VBA, and it needs to run in Excel 2003. In 2007 its easy to simply use the removeduplicates code, but it errors out in 2003.

I need a module of code that will find all the duplicate rows in the worksheet, and simply delete the entire row.
The Data looks like this:

BLG109T 04-Jun-2012
BLG109T 05-Jun-2012
BLG109T 06-Jun-2012
BLG109T 07-Jun-2012
BLG109T 10-Jun-2012
BLG109T 10-Jun-2012
BLG111T 04-Jun-2012
BLG111T 05-Jun-2012
BLG111T 06-Jun-2012
BLG111T 06-Jun-2012
BLG111T 07-Jun-2012
BLG111T 10-Jun-2012
BLG127T 10-Jun-2012
BLG127T 04-Jun-2012
BLG127T 05-Jun-2012
BLG127T 06-Jun-2012
BLG127T 06-Jun-2012
BLG127T 07-Jun-2012
BLG128T 07-Jun-2012
BLG128T 10-Jun-2012
BLG128T 04-Jun-2012
BLG128T 05-Jun-2012
BLG128T 05-Jun-2012

etc.

Any help would be greatly appreciated.

Regards,
Chris

Hey,

Thanks for the help, but I've tried that already. That code doesn't work in Excel 2003. I need something that works in 2003 as I'm locked into 2003 at work.

Chris

Hi Benisato, try this:

Please Login or Register  to view this content.

That worked perfectly! Thanks so much for the help

Chris