How do I use VBA to check it a sheet exists or has the correct name

[hellfire45]

I need to check a workbook to make sure that certain worksheets exist and that they're named correctly. I'm been trying something like what is below but they aren't working. Any suggestions? Thank you again so much!

if Worksheets("Tasks") <> "" then
 MsgBox ("Tasks Sheet Either Missing or Named Incorrectly")
 Workbooks(docname4).Close False
Exit Sub

Also tried

If Not SheetExists("Tasks") Then 
MsgBox ("Tasks Sheet Either Missing or Named Incorrectly")
 Workbooks(docname4).Close False
Exit Sub

 

[NeonRedSharpie]

    For x = 1 To ThisWorkbook.Sheets.Count
        If Sheets(x).Name = "Tasks" Then
            GoTo found
        End If
    Next x

MsgBox ("Tasks Sheet Either Missing or Named Incorrectly")
 Workbooks(docname4).Close False

found:

' code to continue

 

[bbott]

There's probably a more elegant way, but this seems to work:

Sub TskSht()

    On Error GoTo 500
    Sheets("Tasks").Select
    Exit Sub
500
    MsgBox ("No such sheet")
End Sub