Thanks Tom, works great.
Pierre

Tom Ogilvy wrote:
Insert = Name = Define

Name: List1
RefersTo: =Sheet3!$A$1:$A$20

Click the Add Button

then in data validation under source put in

=List1

--
Regards,
Tom Ogilvy

Hi,

[quoted text clipped - 3 lines]
Thanks,
Pierre

--
Message posted via http://www.officekb.com