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