Thanks for the help Trevor but it doesn't work. It doesn't do anything

--
halem
-----------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993
View this thread: http://www.excelforum.com/showthread.php?threadid=27059

The routine works its way up from the bottom and uses COUNTIF to count the
cells in column A which have the same value as the current cell. If the
count is greater than 1 there is at least one duplicate and it deletes the
entire row.

If it isn't working then there aren't any duplicates in the column. Could
there be any spaces after the values you can see ? Maybe you have a
different worksheet selected ? It works consistently on my test data but,
for example, "b" and "b " would look the same but would not be considered as
duplicates.

Perhaps you could provide a link to the spreadsheet through the Excel Forum.

Regards

Trevor


"halem2" wrote in message
...

Thanks for the help Trevor but it doesn't work. It doesn't do anything.


--
halem2
------------------------------------------------------------------------
halem2's Profile:
http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=270599