| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add new worksheet after specific sheet
Excel 2003 on WinXL
I have a workbook with several named sheets. I wish to programatically add a new named sheet after a named existing sheet (lets call it MySheet) without Activating or selecting MySheet. AddSheets After... doesnt seem to allow this. -- donwb |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add new worksheet after specific sheet
Worksheets.Add(After:=Worksheets("MySheet")).Name = "NewSheet"
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "donbowyer" wrote in message ... Excel 2003 on WinXL I have a workbook with several named sheets. I wish to programatically add a new named sheet after a named existing sheet (lets call it MySheet) without Activating or selecting MySheet. AddSheets After... doesnt seem to allow this. -- donwb |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add new worksheet after specific sheet
Thanks Bob - it was the syntax that evaded me
-- donwb "Bob Phillips" wrote: Worksheets.Add(After:=Worksheets("MySheet")).Name = "NewSheet" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "donbowyer" wrote in message ... Excel 2003 on WinXL I have a workbook with several named sheets. I wish to programatically add a new named sheet after a named existing sheet (lets call it MySheet) without Activating or selecting MySheet. AddSheets After... doesnt seem to allow this. -- donwb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing Specific Data from Master Sheet to Another Sheet | New Users to Excel | |||
| Send data from userform to specific cell on specific sheet? | Excel Programming | |||
| Navigate to specific cell on specific worksheet | Excel Programming | |||
| Copy and pasting specific sheet data to a master worksheet | Excel Programming | |||
| Entering Data in 1 Worksheet to appear in a specific format in Sheet 2 | Excel Programming | |||
Linear Mode
