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