in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet?
 

in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to
the newly created copy of this sheet?

dim newWks as worksheet

with activeworkbook
.sheets("mysheet).copy _
befo=.sheets(1)
end with
set newwks = activesheet
newwks.name = "this is a new sheet!"

(the activesheet is the one that just got created.)

Daniel wrote:

in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to
the newly created copy of this sheet?

--

Dave Peterson