I have set up a dropdown list in my worksheet using a list from another
worksheet inside the same workbook. I have set the validation-Settings page
up so it should not allow any blank cells (the ignore blank box is unchecked)
in the column of my dropdown list but it continues to allow blank cells.
What am I not doing correctly to not allow blank cells?