Exclude one sheet name from "For Each ws In Worksheets"

[GeeWhiz7]

Hi there,

I have a macro that walks through each worksheet in a workbook and gets data to collate into another workbook.
I would like to add another worksheet where I will analyze the data that has been collated.

How can I keep the analysis worksheet that I created after the initial macro run from being part of the "For Each ws In Worksheets" example if i run the macro again.

VB snippet. you can see I'm already not including the "Start Here" worksheet, but when I add an AND avoid the analysis worksheet, things don't seem to work very well.
Wondering if anyone knows a better way.

Thank you,

    For Each ws In Worksheets
        If ws.Name <> "Start Here" Then
            If ws.UsedRange.Rows.count > maxRow Then
                maxRow = ws.UsedRange.Rows.count
                Set maxTickerWS = ws
            End If
        End If
    Next

 

[DanteAmor]

I didn't quite understand what you need.
Do you want to exclude multiple sheets?

Try this:

  For Each ws In Worksheets
    Select Case ws.Name
      Case "Start Here", "Sheet1", "Sheet8"   'Excluded sheets
      
      Case Else
        If ws.UsedRange.Rows.Count > maxRow Then
          maxRow = ws.UsedRange.Rows.Count
          Set maxTickerWS = ws
        End If
    End Select
  Next

 

[GeeWhiz7]

I didn't quite understand what you need.
Do you want to exclude multiple sheets?

Try this:

  For Each ws In Worksheets
    Select Case ws.Name
      Case "Start Here", "Sheet1", "Sheet8"   'Excluded sheets
     
      Case Else
        If ws.UsedRange.Rows.Count > maxRow Then
          maxRow = ws.UsedRange.Rows.Count
          Set maxTickerWS = ws
        End If
    End Select
  Next

I think I didn’t quite understand what I need either. Seems like I fix one thing only to create or find another flaw.
Your suggestion works, thank you!

 

[DanteAmor]

Im glad to help you. Thanks for the feedback.