Help writing Worksheet Loops (Limited number)

[hellfire45]

I want to write a loop that will allow me to run some major formatting on a series of worksheets. This book has like 45 worksheets in it and I only need the loop to hit sheets 2 through 11 (that is the numeric order of the sheets from left to right).

Any suggestions about how to hit these sheets without activating every sheet and retyping all the lines of code?

thank you so much!

 

[VoG]

Try like this

Dim i As Long
For i = 2 To 11
    With worksheets(i)
    'your code here
    End With
Next i