Multiple For Each Loops with Worksheet Object?

[Entellex]

Is it possible to have multiple For Each Loops in one Procedure that targets the Work Sheet Object

IE:

For each ws in ThisWorkbook.Worksheets
'Do This
Next ws


For each ws in ThisWorkbook.Worksheets
'Do That
Next ws


Or does the variable name have to be different?

[inq80]

Shouldn't be as far as I'm aware. This references it:

http://www.excel-easy.com/vba/loop.html

Please Login or Register  to view this content.

[Norie]

Do you need 2 separate loops for the same workbook and worksheets?

[Entellex]

@Norie I need to separate loops for go through the worksheets, it will be in two different areas of the code and do something different