Worksheets are numbered from left to right regardless of their names.


Method One:

for i = 2 to 6
sheets(i).select
<Your Code
next i


Method Two (preferred due to unknowns such as hidden sheets):

for i = 2 to 6
sheets("Sheet" & i).select
<Your Code
next i


HTH,
Paul

"Jay" wrote in message
...
I have a chunk of code that I would like to run thru on only certain
worksheets. How do I loop thru say only Sheets 2-6?