How to exclude known sheets in VBA Excel

[mhni]

Sh is defined as a worksheets

I use a loop to perform "things" with each sheet such as

Please Login or Register  to view this content.

I do know that there are sheets that I want to EXCLUDE from this loop. How would I accomplish that? For example, suppose we wanted to exclude Sheets named "One" "Two" and "Three"....

Thanks!

[rylo]

Hi

try something like

Please Login or Register  to view this content.

rylo

[Leith Ross]

Hello mhni,

Another more flexible method is to use a Select Case statement. It is easier to read and maintain.

Please Login or Register  to view this content.