Got a question,
I have imported this code myself and it works great however it doesn
do "exactly" what I want.

I have the 3 columns Date, IP and Hostname. Your macro will only remov
a duplicate if the Date, IP and Hostname are all duplicated.

The problem I face, however, is that I want to remove the duplicate ro
based on the Hostname column not all 3.

Is that possible using your code??

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