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



wrote:

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