How To Find Sheet By Name

April 30, 2011 at 01:39:41
Specs: Windows XP
I have many sheets in my worksheet, how to find a sheet easily? Pleas guide me.
over 80th sheets in my worksheet. They already name each sheet by name and number. I want to find a sheet easily? I use Microsoft Excel 2003 and 2007

See More: How To Find Sheet By Name

Report •

#1
April 30, 2011 at 07:27:08
Here are some helpful things to know:

http://chandoo.org/wp/2009/02/16/ex...

And here are the big guns:

http://www.mrexcel.com/articles/tab...


Report •

#2
April 30, 2011 at 08:00:52
While the links that Paul1149 suggested are certainly more elegant than this solution, sometimes simplicity isn't a bad way to go.

If you know the name of the sheet you are looking for, this code will activate it.

Create a toolbar icon to access the macro so it is available regardless of which sheet you are viewing.

Click the button and enter the name of the sheet you want to activate:

Sub FindSheet()
Dim mySht As String
GetShtName:
On Error GoTo noSht
'Get sheet name from user
 mySht = Application.InputBox("Please Enter Sheet Name")
'Exit if Canceled
   If mySht = "False" Then Exit Sub
'Activate Sheet and Exit
    Sheets(mySht).Activate
    Exit Sub
noSht:
'Present message if sheet not found
   MsgBox "Sorry, there is no sheet by that " & _
           "name in the workbook." & vbCrLf & vbCrLf & _
           "Please try again."
 GoTo GetShtName
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
April 30, 2011 at 08:08:56

Report •
Related Solutions


Ask Question