Select Worksheet 2 to TotSheet

[helgeroe]

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I would appreciate if someone could help me out with this one.<o></o>
<o></o>
Numbers of worksheets in workbook is defined as: TotSheet
<o></o>
I would like to select all worksheets except the first: 2 -> TotSheet.<o></o>
<o></o>
Any way to choose a range of sheets in VBA?<o></o>
<o></o>
Thanks. <o></o>
<o></o>
Helge

 

[venkat1926]

safer to go about like this
suppose the first sheet's name is "AAA"

sub test()
dim j as integer, k as integer
k=worksheets.count
for j=1 to  k
if sheets(j).name="AAA" then goto looping
<put your code here >
...
looping:
next 
end sub

If there is a bug post back