Is there a specific code that i can use to remove duplicates from a list. I
want to be able to do this using code rather than manually so that when I
copy in a large list of data I can make a copy of one of the columns and
remove the duplicates from this and paste it on another worksheet of the
workbook.

Thank you very much for your help,

Michelle