Selecting a sheet by codename

[Dr.Schwartz]

I have a sheet with the codename P1. Can anyone supply me with the syntax for
selecting/activating the sheet by using the codename?

Thanks
The Doctor

 

[SoC]

Try something like:

worksheets("P1").activate

SoC

 

[Norman Jones]

Hi Dr.Schwartz,

P1.Select

or

P1.Activate

 

[Tom Ogilvy]

Back on 25 August, Paul responded to the same question:

Sheet1.Select

--
Paul B


To which you replied:

Very simple indeed - thanks Paul

:

--

Regards,

Tom Ogilvy