Hi,

I want to fill a combo box with alternative dates based on a list given in cells H5:H??" .
The combo box should contain all unique values of the list given in H5:H??

The problem is that I dont know the lenght of the list , it can be 1 to 200 dates .
Therefore I can't use the standard "Input range" bacause it will add all "blank" cells aswell.
Also, if I use "input range" it will add all values and not only the unique ones.

So,
question is:

How to I fill a combo box with the unique values of the list given in H5 to H?? ?
X nr of rows and I dont want the combo box to show "blank" values.

Thanks!

//

Per