My spreadsheet contains a range of cells with dates. They are in random order and there are duplicates
I want to use this range in a listbox on a userform. But I want to prevent it showing duplicates and preferably would have the dates ordered from old to new.
I am trying to do this by copying the data elsewhere, sorting and then removing duplicates, but I guess there must be a more elegant way to do this.
Anybody any suggestions?
I want to use this range in a listbox on a userform. But I want to prevent it showing duplicates and preferably would have the dates ordered from old to new.
I am trying to do this by copying the data elsewhere, sorting and then removing duplicates, but I guess there must be a more elegant way to do this.
Anybody any suggestions?
