If Worksheet Name Does not equal more than one.

Hi,
you could use Select Case statement instead of If statement. Like this

    Select Case MyWorksheetName
    Case "Sheet1", "Sheet2"
        'Do nothing

    Case Else
        'Do something

    End Select

Assuming MyWorksheetName is variable that holds the sheet name you want to check. There may be other solutions, but that's the first that comes to my mind based on information provided.