Thanks a lot. This has been very helpfull!

"RagDyeR" wrote:


Debra Dalgleish's web site explains how to easily accomplish this:

http://www.contextures.com/xlDataVal05.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Henk" wrote in message
...
In data validation I'm trying to refer to a list in a different sheet but I
didnt work. I have followed the help function in Microsoft but I keep
getting
the message that in data validation you cannot refer to a list in a
different
workbook.