VBA code to run on specific sheet numbers

[valmir]

Hi everyone.
I understand that this part of the VBA Code
Dim i As Long
For i = 1 To 14
Sheets(i).Activate
means it will run all all sheets from 1 to 14.
What if I want it to run on specific sheet numbers, for example: 1 to 3; 5 to 7 and 9 or else, is there a way to skip some sheet numbers, like run from 1 to 14 except 3, 8 and 9 for example?

 

[Fluff]

You could use something like

   Dim i As Long
   For i = 1 To 14
      Select Case i
         Case 1 To 3, 5 To 7, 9
         Sheets(i).Select
      End Select
   Next i

 

[valmir]

Perfect! Thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.