Hi

You have to define the list as named range (I myself prefer dynamic named
ranges in such cases), and then you use this name as list source.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Dean" wrote in message
...
My client likes these drop downs (using data, then validation, then list),
but I notice that, if the list you want to use is on another worksheet,
you can't do it. Since this worksheet will be replicated 100s of times in
the workbook, I really don't want to have to have a copy of the list on
every such sheet. Is there some other similar way to have a pre-populated
set of choices for a cell, where the choices come from another worksheet?
Also, I have noticed that, when my biggest spreadsheets crash and go into
repair mode, it is always the data validation drop downs that get wiped
out, sometimes all the formatting, but not always, but always these drop
downs get wiped out. So, perhaps there should be (and is) a better way/

Thanks for any help!
Dean