Setting a collection of worksheets to feed to a For Each loop

[JimDandy]

I can get a For Each loop to go through all worksheets in my workbook but how can I limit the loop to a subset or just a collection of worksheets? What I need to do should not be done on all my worksheets.

Please Login or Register  to view this content.

[mjr veverka]

e.g.:

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

You can also use an array of sheets

For Each wks In Worksheets(Array("A", "B", "C"))

Next

This loop applies to the sheet names, A, B and C and any other sheet name in the sheet collection will be ignored.

[JimDandy]

Thanks, both of these with slight modifications can work to solve my problem....