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