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
Bookmarks