How can I populate a list box with a range of cells but some of the numbers
in the cells are duplicates.

Ie:
Range
456
456
123
123

I want the list box to show only one(1) 456 and only one(1) 123. Is this
possible? What does the macro look like? I do not know what numbers I will
need because they change weekly. So I can't us the addItem command.

Eric