Hi

I am trying to remove duplicate email from 16 column of excel file. I have tried remove duplicate,data validation,highlighted duplicate then filter but nothing work for my problem as I dont have same raw. All column has only email address. How can i do it? VBA? I have tried this VBA code. Seems nothing happen after running.

Sub RemoveDups()

Dim ws As Worksheet
Dim col As Range

For Each col In Sheet2.Range("A:M").Columns
Sheet2.Range(col.Address).RemoveDuplicates Columns:=1, Header:=xlNo
Next col

End Sub

Any help would be appreciated