Activate Previous worksheet after adding a new worksheet

[Chingangel]

I want to activate the worksheet that was active before I added a new
sheet to the workbook in VBA for excel. Can anyone help me on how to do
that?

 

[Dave Peterson]

dim mySelection as range
set myselection = selection
'add your worksheet
application.goto myselection

 

[JakeyC]

Not sure if this post worked so apologies if this is a duplicate:

Option Explicit

Sub ()
Dim CurrentSheet, NewSheet As Worksheet

Set CurrentSheet = ActiveSheet
Set NewSheet = Worksheets.Add

CurrentSheet.Activate
End Sub

 

[JakeyC]

I think this should work:

Option Explicit

Sub ()
Dim CurrentSheet, NewSheet As Worksheet

Set CurrentSheet = ActiveSheet
Set NewSheet = Worksheets.Add

CurrentSheet.Activate
End Sub