Ignore sheet in loop

[cuetipper]

So how do I ignore the worksheet named "Data".

For Each ws In Sheets
if ws.name="Data" next ws end if
else
'do stuff here
next ws

 

[Fluff]

Like

For Each ws In Sheets
   If ws.Name <> "Data" Then
      'do stuff here
   End If
Next ws

 

[cuetipper]

thank you

 

[Fluff]

You're welcome

 

[cuetipper]

Can I modify that to ignore more than one sheet or do I repeat the line?

For Each ws In Sheets
If ws.Name <> "Data" Then

If ws.Name <> "recap" Then​

'do stuff here
End If
Next ws​

 

[Fluff]

Try

For Each ws In Sheets
   If ws.Name <> "Data" And ws.Name <> "recap" Then
      'do stuff here
   End If
Next ws

 

[cuetipper]

cool. thanks

 

[Fluff]

 

[cuetipper]

I can not get this to work.
I added tot he top of my code:
For Each WS In Application.Worksheets
If WS.Name <> "Data" Then
WS.Activate


and then at the end:

End If
Next
End Sub


and I get error next without for.
ant idea why?

 

[Fluff]

Without seeing the entire code, I can't tell