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

Hi Dr.Schwartz,

P1.Select

or

P1.Activate

---
Regards,
Norman



"Dr.Schwartz" wrote in message
...
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

Try something like:

worksheets("P1").activate

SoC


---
Message posted from http://www.ExcelForum.com/

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

Sheet1.Select

--
Paul B


To which you replied:

"Dr.Schwartz" wrote in message
...

Very simple indeed - thanks Paul



"Paul B" wrote:



Sheet1.Select



--

Paul B



--

Regards,

Tom Ogilvy



"Dr.Schwartz" wrote in message
...
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