On 12 avr, 21:33, pat67 wrote:
I am setting up a list for cells. I am using data validation and
picking a named range. I have no issue if the range is in the active
workbook. but i need to use a range from a different workbook. is that
possible? if so how?

Thanks

Hello,

If you want to use a named range from a closed workbook, in a
worksheet formula for example like average, you can enter your formula
like this
= average("[path to the closed workbook]\[closed workbook name].xls"!
[name of the range]

HTH