That should work. Did you choose "List" for the Allow Field? When you enter
your range, did you start it with an = sign?
=E9:E39 will look in that range.
E9:E39 will only accept the literal value "E9:E39"
HTH,
Elkar
"edwardpestian" wrote:
I need to validate an entry against a range of dates. For example, if
the user entered a date, that was not in the range E9:E39 the would get
a specified message: "Date is not found in the range." I tried using
datavalidation, but it would not accept the range.
Thanks in advance.
ep
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=550168