Data Validation List with no empty cells

[rbrhodes]

Hi,

You could sort the list then redo the dat validation for the new last row. or a macro to delete blank rows or and advanced fiter (unique, in place)...