Use the Advanced filter and select the uniques check box in the dialog.

Data=Filter=Advanced filter

--
Regards,
Tom Ogilvy

"Ray" wrote in message
...
Column A has 1000 rows of entries, some are duplicates.
How can I set up a Macro to delete duplicate entries.

Thanks in advance!
Ray