delete duplicate entries in worksheet

Hi!

In my worksheet, In columnAT I have a 5 digit number that shows up two or three times in that column. I want to make vba code to get rid of duplicate entries in that column.
(I want to get rid of the number the 2nd time it shows up.)

thanks for the help!

I have the following...(it looks like it works, but i'm not sure about it...)

Please Login or Register  to view this content.

It would be more efficient to automate the use of Advanced Filter, using the option to copy unique values to another location. Looping is inefficient as it goes cell-by-cell. Whereas the filter will act on the entire range of cells at once.

Clear the contents of column-a and paste in the results of the filter.