I currently do this inside a subroutine

Set Holidays_r = Names("Holidays").RefersToRange

to access a certain range on a sheet.

I was wondering how would I access the same named range that exists on
a seperate sheet that may or may not be opened? Do I have to open
that workbook first?


Thanks