I have a list that I wish to copy but upon pasteing I would like any repeated
items in the list not to be copied.

Trying to work it out using other VB I've copied for drop down menus but
can't seem to get it to work.

TIA
Matthew