Ignore a number of sheets before checking rest

[adamprocter]

I have a macro button on sheet 1 to check sheets for a certain piece of data which is great but I need to ignore sheets 1 2 and 3

Dim ws As Worksheet
If ws.Name <> "My sheet 1" Or "My sheet 2" Or "My sheet 3" Then

Cant seem to figure it out

 

[njimack]

Sub x()
Dim ws As Worksheet


Application.ScreenUpdating = False


For Each ws In ThisWorkbook.Worksheets
    Select Case ws.Name
        Case "Sheet1", "Sheet2", "Sheet3"
        Case Else:
            'your code here
    End Select
Next ws


Application.ScreenUpdating = True


End Sub

 

[adamprocter]

thanks thats done it :D