add non active worksheet

C

cluckers

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

Luke M

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
 
C

cluckers

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

Gord Dibben

Dim startplace As String
startplace = ActiveSheet.Name
Worksheets.Add().Name = "Sheet14"
Sheets(startplace).Select


Gord Dibben MS Excel MVP
 
Top