Hi Mark,

Try using a dynamic range for the Data Validation List.

For information on the use of dynamic ranges, see Debra Dalgleish's page on
dynamic ranges at:

http://www.contextures.com/xlNames01.html#Dynamic


---
Regards,
Norman



"mark hansen" wrote in message
.. .
I have created many spreadsheet for other users and have tried to set them
up, as much as possible, so they add their own information into cells so
they can be in the data validation from list drop down boxes. I have had
to go back and add more room in the data validation list because it was
longer than I expected.

Is there I way I can set up the data validation so the list they get will
grow when they add more to the list?

Thanks
Mark