Thank you so much, it's my first time using the microsoft online community,
will definately use it again!

"Don Guillett" wrote:

Or, simply select the range and use the name box unless you want it to be
dynamic. Then use a formula such as offset to define your range name.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sean Timmons" wrote in message
...
That is, highlight the list, Insert Name Define and give it a name
there.

"Don Guillett" wrote:

e: how do I share data validation lists between worksheets?

In the future please put your subject in the subject line and question in
the BODY of the msg.
make a list somewhere and NAME it something like vallist. then

=vallist

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DL101" wrote in message
...