Many thanks for the help. By the way, is there way to determine th
number of rows so I can use a For loop instead of writing all that? Th
reason is I'm not only doing for 10 or 100...actually my projec
involves 48 thousand records that I need to check for duplicate an
copy the unique ID to column D.

ljCharli

--
Message posted from http://www.ExcelForum.com