New worksheet position
 

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

New worksheet position
 

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

"Jim" wrote:

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

New worksheet position
 

Workshests.Add After:=Worksheets(1)

--
HTH

Bob

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

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

New worksheet position
 

Typo

Worksheets.Add After:=Worksheets(1)

--
HTH

Bob

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

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

New worksheet position
 

Worksheets.Add After:=Sheets(1)


Gord Dibben MS Excel MVP

On Tue, 29 Jul 2008 11:53:37 -0700, Jim
wrote:

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

New worksheet position
 

Thanks!