Hi everybody
I have a named range "Test" for the range A2:A100 and there are empty cells in my range.
When I made a data validation list for the range "Test" the empty cells are embedded in the list
I want to get rid of the empty cells from my list