Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
New worksheet position
Thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add worksheet at end or last position | Excel Discussion (Misc queries) | |||
Worksheet Tas position | Excel Discussion (Misc queries) | |||
Set position into a worksheet using vba | Charts and Charting in Excel | |||
Worksheet position | Excel Programming | |||
Worksheet Position | Excel Programming |