Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new Sheet Q
The following is an extract of some code that creates a new sheet
after the activesheet. How could I tweak to insert this new sheet after the sheet called "Start" - this sheet called Start is actual just to the right of the active sheet, to the new sheet I wish to create will now be to the right of the sheet called "Start" and thus 2 sheets to the right of the active sheet Thanks If SheetExists(newShtName) Then MsgBox "You have already created this week.If you have made an error, delete the week sheet tab and e-mail again", vbCritical Exit Sub End If ActiveSheet.Copy after:=ActiveSheet ActiveSheet.Name = newShtName ActiveSheet.Tab.ColorIndex = -4142 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new Sheet Q
Try this
ActiveSheet.Copy after:=Sheets("Start") Mike "Seanie" wrote: The following is an extract of some code that creates a new sheet after the activesheet. How could I tweak to insert this new sheet after the sheet called "Start" - this sheet called Start is actual just to the right of the active sheet, to the new sheet I wish to create will now be to the right of the sheet called "Start" and thus 2 sheets to the right of the active sheet Thanks If SheetExists(newShtName) Then MsgBox "You have already created this week.If you have made an error, delete the week sheet tab and e-mail again", vbCritical Exit Sub End If ActiveSheet.Copy after:=ActiveSheet ActiveSheet.Name = newShtName ActiveSheet.Tab.ColorIndex = -4142 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new Sheet Q
If SheetExists(newShtName) Then MsgBox "You have already created this week.If you have made an error, delete the week sheet tab and e-mail again", vbCritical Exit Sub End If ActiveSheet.Copy after:=Sheets("Start") ActiveSheet.Name = newShtName ActiveSheet.Tab.ColorIndex = -4142 -- The Code Cage Team Regards, The Code Cage Team www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=25369 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create Login & Log out Spread sheet in Excel with automated Attendance sheet | Excel Worksheet Functions | |||
Create new sheets based off Data sheet, and template sheet | Excel Programming | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
How to create a Macro to Copy Information in one sheet to another sheet. | Excel Programming |