Searching for a Worksheet name

B

Bob Phillips

This is some example code

Dim sh As Worksheet

On Error Resume Next
Set sh = Worksheets("Bob")
On Error GoTo 0
If sh Is Nothing Then
MsgBox "Bob not found"
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
N

Norman Harker

Hi Moni!

Bob has given you code for this but you may not be aware of right
clicking any of the small arrows to the left of the worksheet tabs.
This brings up a list of the worksheets.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top