Dear JBeaucaire,

The second code is working.


Thanks
Harshad

"JBeaucaire" wrote:

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-105...g-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" wrote:

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