On Error Resume Next
Set sh = Worksheets("specificsheet")
On Erroro Goto 0
If sh Is Nothing then
Worksheets.Add.Name = Worksheets("specificsheet")
Else
sh.ACtivate
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CLR" wrote in message
...
Hi All......

If someone would be so kind, I would appreciate finding out how to
determine
is a sheet named "specificsheet" already exists, and if so to switch to
it,
otherwise to create it and then switch to it......

Thanking you muchly in advance,
Vaya con Dios,
Chuck, CABGx3