Hi thanks for your replies I was just being this ,

I put a list in one colum then selected this list to go into the
validation and then hid the colum and all works fine now

cheers


--
timboellis
------------------------------------------------------------------------
timboellis's Profile: http://www.excelforum.com/member.php...o&userid=25381
View this thread: http://www.excelforum.com/showthread...hreadid=396870