Nested For Each Sheet Loop Issue

[danbrawl93]

Hey guys,

I am trying to run the following (simplified) code:

For Each sh In Worksheets
' I want to find if a particular sheet name exists
If sh.Name = "Desired Name" Then

    ' Now as a result I want to perform changes on specific sheets
    For Each sh In Worksheets
    If sh.name = "Example Name 1" Then
    ' Perform changes
    ElseIf sh.Name = "Example Name 2" Then
    ' Perform changes
    End If
    Next sh

End If
Next sh

The For variable (sh in this case) is being used more than once, so the code doesn't work, but I need to scan through the worksheets in the nested loop. Please can you suggest ways to work around the issue!

Thanks so much in advance,

Dan

 

[ukmikeb]

Hi

Use another variable for the inner loop.

hth

 

[GTO]

Can you explain why we need to run thru all the worksheets for each worksheet?

 

[danbrawl93]

Hey,

That would be great. But how do I use a different variable to represent worksheets? (i.e. I'm using "sh" to reference worksheets, what other variable name would be applicable?).

Thanks!

 

[ukmikeb]

Hey,

That would be great. But how do I use a different variable to represent worksheets? (i.e. I'm using "sh" to reference worksheets, what other variable name would be applicable?).

Thanks!

Instead of using sh for the inner loop use sh1, for example.

Don't forget that sh/sh1 is the means you have to step through the collection of worksheets and therefore reference the name of each worksheet.