One way:

Option Explicit
Sub testme()
Dim iCtr As Long
For iCtr = 2 To Sheets.Count
Sheets(iCtr).Select Replace:=CBool(iCtr = 2)
Next iCtr
End Sub




JEFF wrote:

Hello,

My workbook has a first sheet that is always the same. I then have VBA that
imports new sheets from workbooks in another folder. I wish to do something
to all those sheets once brought in, but not the first. Of course the number
of sheets (and their names) varies....

How do select a sheet array that automatically starts with the second sheet
and selects all those after it? In other words, how do I select all
worksheets except sheet 1 (not knowing their names or the number)?

Thanks

--

Dave Peterson