If you don't have a compelling need to do that with VBA, you probably
can use an Advanced Filter to create a list of unique records.

See Debra Dalgleish's website:

http://www.contextures.com/xladvfilter01.html

Check this section: Filter Unique Records

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=520376