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 |
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 |