Hi,
I have a sheet Settings, A1 contains value "Check_Values", A2:A? are values to be allowed in a drop-down data validation list, where ? is unknown row number.
For a dynamic range, I have named A1 ("Check_Values") and then use formula to name range ("Check_Values_List") for dynamic list...