I have a form which when loaded populates the value/text of cells , say A1
to A10 into a combo box using the additem method.
Within this range off cells are duplicate entries and blank cells. I only
want to add to the combo box one occurrence, and ignore blank & duplicate
cells.
For example if below, were cells A1 to A10, i only want to see John, Dave &
Steve added once to the combo box.

John
John

Dave
Steve
John

Dave
John
Steve

Thanks again

Dave