Presently your code is stop executing duplicates if a row as no data a
column c, so I think it is stopping when no data is found.

What do you mean by last row?. Do you have blank rows between rows,
blank row represent last row?

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=27794