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