Hi

For XL2007 it is Data tabData Validation.

But what you really need to do is create a dynamic list for your validation
range.
Supposing your list is on Sheet2, column A then
Formula tabDefine NameNamemyListrefers to
=OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A))

In your DV, set the list Source=myList
--
Regards
Roger Govier

"db" wrote in message
...

Stefi

Thanks for the quick response - I forgot to mention I am using Excel 2007.
I do not see any Validation - Select List option in the Data tab ... is
it
somewhere else?

thanks

dan


"Stefi" wrote:

DataValidationSelect list, and adjust Source range or Delete All!

Regards,
Stefi