Deleting duplicates in a macro

[tryaz]

I am trying to figure out how to delete duplicate values in cells a1:a200

What should my macro field look like?

[DonkeyOte]

If you're using XL2007, record yourself doing the following:

1 - highlight column containing duplicates

2 - navigate to Data tab on Ribbon

3 - select Remove Duplicates (follow prompts)

(and remember to stop recording)