Just name the =sheet3!$c$1:sheet3!$c$20 range and you can use thatnamed range in the validation list. I do this all the time. Why theywould allow it to work as a named range but not as a hard-coded rangeis beyond me.