Delete duplicates in each column

Originally Posted by pike

Hi softy.
Welcome to the forum and thanks for posting.
The synatx

RemoveDuplicates Columns:=1, Header:=  xlYes

will only work in xl2007 and xl2010
in xl2003 you can use the auto filter

Hi, Thanks for early reply
unable to solve the issue. showing compile error.
I am using macro like this

Sub Macro1()
RemoveDuplicates Columns:=1, Header:=xlYes
End Sub

I am very new to macros hence ,I may be doing wrong or might not have followed you as you desired. Please guide me in detail.


One more question , can the same thing be done in rows also?