Sorry, i've tried naming the range of cells containing my list, but when I try to point the validation to that range I get a message advising me that I cannot use a range on a different worksheet or workbook.
Thanks for the attempt though...any other suggestions I can try ??