Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add non active worksheet
How do I add a new sheet to my acitve workbook without makin it the active
sheet. I tired Worksheets.Add().Name = "Sheet2" but it makes it active. Normally I cold just active the other sheet but the primary sheet name will not be consistent. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
add non active worksheet
You could get around not knowing what the current active sheet is by doing
this: StartPlace = ActiveSheet.Name Worksheets.Add().Name = "Sheet2" Sheets(StartPlace).Select -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "cluckers" wrote: How do I add a new sheet to my acitve workbook without makin it the active sheet. I tired Worksheets.Add().Name = "Sheet2" but it makes it active. Normally I cold just active the other sheet but the primary sheet name will not be consistent. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
add non active worksheet
it gets the compile error "variable not defined".
Dim startplace As Worksheet Set startplace = ActiveSheet.Name Worksheets.Add().Name = "Sheet2" Sheets(startplace).Select this code returns 'object required' "Luke M" wrote: You could get around not knowing what the current active sheet is by doing this: StartPlace = ActiveSheet.Name Worksheets.Add().Name = "Sheet2" Sheets(StartPlace).Select -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "cluckers" wrote: How do I add a new sheet to my acitve workbook without makin it the active sheet. I tired Worksheets.Add().Name = "Sheet2" but it makes it active. Normally I cold just active the other sheet but the primary sheet name will not be consistent. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
add non active worksheet
Dim startplace As String
startplace = ActiveSheet.Name Worksheets.Add().Name = "Sheet14" Sheets(startplace).Select Gord Dibben MS Excel MVP On Thu, 20 Aug 2009 13:17:01 -0700, cluckers wrote: it gets the compile error "variable not defined". Dim startplace As Worksheet Set startplace = ActiveSheet.Name Worksheets.Add().Name = "Sheet2" Sheets(startplace).Select this code returns 'object required' "Luke M" wrote: You could get around not knowing what the current active sheet is by doing this: StartPlace = ActiveSheet.Name Worksheets.Add().Name = "Sheet2" Sheets(StartPlace).Select -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "cluckers" wrote: How do I add a new sheet to my acitve workbook without makin it the active sheet. I tired Worksheets.Add().Name = "Sheet2" but it makes it active. Normally I cold just active the other sheet but the primary sheet name will not be consistent. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying the active worksheet to another worksheet in the same work | Excel Worksheet Functions | |||
E-mailing the active worksheet | Excel Worksheet Functions | |||
name an active worksheet | Excel Worksheet Functions | |||
how can I get the name of the active worksheet? | Excel Worksheet Functions | |||
email active worksheet | Excel Discussion (Misc queries) |