Unhide sheet based on NamedRange?
 

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

Unhide sheet based on NamedRange?
 

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

Unhide sheet based on NamedRange?
 

Tom,

Many thanks for the prompt reply.

Perfect. Just what l want!

Regards
"Tom Ogilvy" wrote in message
...
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