Cheers Bernie, it seems like it works but at the moment the math doesn't
work out.
Original: 4434
Dup: 389
Anticipated result: 4045
Actual result: 4082
which looks like 37 of the duplicates weren't duplicates.
I'll have to do a manual check to validate this.
It would help if I understood your macro.
98% of it I haven't come across before
--
Daminc
------------------------------------------------------------------------
Daminc's Profile:
http://www.excelforum.com/member.php...o&userid=27074
View this thread:
http://www.excelforum.com/showthread...hreadid=493823