How to loop through a worksheet if it has a specific name?

[prinzip]

Hello.

I have a code that checks for data in all the worksheets of a workbook, but i want one specific (based on its name) excluded from the search. This is what i wrote but it's not working:

   For Each ws In Worksheets
   

   
        'Loop Info worksheet
        If ws.Name = "Info" Then

            Next ws

        End
     
[data checking statements]

Next ws

How can it be edited?

 

[adam087]

Try this...

Option Explicit

Public Sub SubName()


Dim ws As Worksheet


For Each ws In ThisWorkbook


    If ws.Name <> "Info" Then
        'do something
    Else
        'no nothing'
    End If


Next ws


End Sub

Adam

 

[prinzip]

Try this...

Option Explicit

Public Sub SubName()


Dim ws As Worksheet


For Each ws In ThisWorkbook


    If ws.Name <> "Info" Then
        'do something
    Else
        'no nothing'
    End If


Next ws


End Sub

Adam

Thx Adam, it worked.

 

[adam087]

Cool, thanks for the feedback

/AJ