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