View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Selecting Worksheet Array

Hi Jeff,

One way:

'=============
Public Sub Tester()
Dim i As Long

For i = 2 To ThisWorkbook.Sheets.Count
Sheets(i).Select Replace:=False
Next i

End Sub
'<<=============


---
Regards,
Norman



"JEFF" wrote in message
...
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