find a sheet

R

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

Bob Phillips

Worksheets("Sheet48").Activate

as an example

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
G

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
 
Top