Julie, thanks, but that hasn't worked I'm afraid?

I think I'm losing the wood for the trees!

Basically, I just want to define a range (column A in sheet 2) in cod
and then use these values for the validation list in sheet 1.
followed a link to the Contextures site, which was very good, as
initially I had the values in different workbooks. This worked but a
soon as I closed the workbook with the validation values in th
workbook with the validation applied lost all the list items. So, I'
opening the validation book, copying the list items from the other boo
to a new sheet, hiding/protecting this sheet and then, and this is wher
I'm stuck, trying to apply validation to a column on one of the sheets
using the value in the, now hidden, sheet?

Hopefully this makes sense?

Regards,

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=27358