New worksheet position

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Quick question. How do I set the position of a new tab? When i create a new
sheet, it is in the 1st position, i want it to be in the 2nd position. thanks
 
In 2003 new sheets are inserted to the left of the activesheet so select
Sheet 2 (or second sheet from left) and then

Insert|Worksheet

Mike
 
Workshests.Add After:=Worksheets(1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Typo

Worksheets.Add After:=Worksheets(1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top