Have you checked to make sure you have not included any blank cells in your
list?

"Boomer" wrote in message
...
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?