Mike,
The macro you wrote is very close to something I have been trying to do. Two questions regarding your macro. Can it be modified to leave the duplicates in the sorted data? If yes, how can it be changed?

Also, can your macro be modified to move associated data in other columns along with the data in the column that is being sorted and compared?

I appreciate it.
Mike

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com