Need Macro to delete duplicate Values in Column

Hello can anybody help me with a macro to delete duplicate Values in a selected Column?

In Column A I have duplicate account numbers that I need to eliminate.

Example:

12345
12345
12345
45678
45678

I dont need to eliminate the row, just any duplicate value that might occur.

Thanks

Do you definitiely need a macro for this? You may, if it's something you need to do regularly, or if the data changes often.

Otherwise you can use one of a number of much simpler methods to find or delete duplicates, using either a formula in an adjacent column, or a by running a filter over the data to extract unique values.

Also, did you just want to delete the duplicate value, or delete the row that holds the duplicate? Is the duplicate always alongside the original, or can the data be sorted? Is there ever a duplicate that you want to retain?

James