Hi All,

Is there a way to unhide a hidden sheet based on the the named range.

For example if you want to select a named range say 'MyRange' whose address
is Sheet1!A1:A20 but Sheet1 is hidden is there a simple way to extract the
Sheet name.

TIA

Regards

Michael Beckinsale