loop through specific sheets

[ammartino44]

Hello. How do loop through specific sheets?

I saw this, but I want to select something easily, like sheets 5 through 15, for example.

Please Login or Register  to view this content.

[TMS]

Some options:

Please Login or Register  to view this content.

Regards, TMS

[berlan]

Alternatively from Sheet5 to Sheet15,

Please Login or Register  to view this content.

based on sheetname.

or,

Please Login or Register  to view this content.

based on sheets by index number 5 to 15.


@TMS, I like your approach on using CodeName.

[TMS]

@berlan: mutual appreciation ... I like your alternatives too