Dim sh as Worksheet
set sh = Range("MyRange").Parent
sh.Visible = xlSheetVisible

--
Regards,
Tom Ogilvy


"Michael Beckinsale" wrote:

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