find a sheet

[raj]

hello,

I have an excel file with more than 50 sheets on it. Is it possible to
navigate to or find a particular sheet using its name.

[Bob Phillips]

Worksheets("Sheet48").Activate

as an example

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"raj" <[email protected]> wrote in message
news:[email protected]...
> hello,
>
> I have an excel file with more than 50 sheets on it. Is it possible to
> navigate to or find a particular sheet using its name.

[Gary''s Student]

Two ways:


1. Click on the tab at the bottom of the window
2. Pull-down something like:
Edit > Goto... > Sheet30!A1
--
Gary's Student


"raj" wrote:

> hello,
>
> I have an excel file with more than 50 sheets on it. Is it possible to
> navigate to or find a particular sheet using its name.