Yes there is, you have to name the range then use =MyRange or whatever you
have called it,
Regards,
Alan.
"R0bert0" wrote in
message ...

Is there any way I can set up data validation to use a list that is NOT
on the same worksheet as the cells I am imposing validation on??

Thanks for your help!


--
R0bert0
------------------------------------------------------------------------
R0bert0's Profile:
http://www.excelforum.com/member.php...o&userid=14651
View this thread: http://www.excelforum.com/showthread...hreadid=477433