You're welcome !
Glad it helped ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"DoctorG" wrote in message
...
Yes, the use of a named range works! For some reason, I had been trying to
use $MyList instead of just MyList (where MyList is the name I had
assigned
to the data range for the list) in the validation formula, and it never
worked. Thanks for showing me my error!