Hi Darno,

The link below doesn't give a VBA solution but does suggest ways of
identifying duplicates etc using a helper column, to count # of
appearances try:
=COUNTIF(Range1,Range1)

This is a shortened version of a function shown on Chip's page:
http://www.cpearson.com/excel/duplicat.htm

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=526310