Create a Named Range that is a dynamic range rather than static. Then in
DataValidationList RefersTo enter "=MyRange" with equal sign but
not the quotes; and of course use the name of your dynamic range.
If needed, sort your dynamic range to place all blanks at the bottom.

"Dan" wrote:

Hello. Can anyone tell me how to create a validation list and not show blank
cells or duplicates? I thought this was the default behavior of validation
lists, but it doesn't seem to be the case. Im using Excel 2003 SP1. Thanks.