Hi Jimm

If you use a named range for the validation dropdown it is working with a range from
another worksheet

http://www.contextures.com/xlDataVal02.html

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jimm" wrote in message ...
Does any one have the answer to how I can get the values ( e.g. namedRange )
for a range validation dropdown from a worksheet other that the sheet that
contains the Range.Validation.

Thanks
Jimm