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
|