Delete duplicates in each column

[softy]

I want to remove duplicates in every column.
here is the macro code which removes duplicate entries on declared columns.

Please Login or Register  to view this content.

What I am trying to get is to remove duplicate in every column in entire sheet through a macro. Please help

[pike]

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

Please Login or Register  to view this content.

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

[softy]

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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?

[contaminated]

Visit here