Unique/Distinct Dropdown List
You're welcome
"Max" wrote:
Thanks, Dave. Works well.
Max
"Dave" wrote in message
...
Hi Max,
Haven't thought about the blank, but I guess you could add the following
line:
Range(Cells(3, 4), Cells(Cells(Rows.Count, 4).End(xlUp).Row + 1, 1)).Sort
Key1:=Range("D3")
It will sort the unique list each time, placing the blank cell at the end
where it won't be recognized by a dynamic named range.
Regards - Dave.
|