Unhide sheet based on NamedRange?

[Michael Beckinsale]

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

[Tom Ogilvy]

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
>
>
>

[Michael Beckinsale]

Tom,

Many thanks for the prompt reply.

Perfect. Just what l want!

Regards
"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
>>