How to remove repeated email ids by macro?

[Harshad]

i have so many repeated mail ids, i want to sort it, so that it remove all
repeated mail ids.
Pls help

 

[JBeaucaire]

Run this macro. It will ask you to highlight your range of email addresses,
then ask you to select a range of cells to copy your unique values to. Make
sure you pick enough cells for the second range to receive the new list.

The code is on this page, be sure to use the SECOND version further down the
page:

http://en.allexperts.com/q/Excel-1059/2008/8/VBA-code-extracting-unique-1.htm

Hope this helps.

-
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.

 

[Harshad]

Dear JBeaucaire,

The second code is working.


Thanks
Harshad

 

[Shane Devenshire]

Hi,

If you are using 2007, no need for a macro, just choose Data, Remove
Duplicates.

 

[Harshad]

Thank you for further information,
Actually i'm using Exl 2000.

Thank you again.