in VBA Sheets("mysheet").Copy Before:=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 _
before:=.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 Before:=Sheets(1) how do i get a reference to
> the newly created copy of this sheet?

--

Dave Peterson

dim newWks as worksheet

with activeworkbook
.sheets("mysheet).copy _
before:=.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 Before:=Sheets(1) how do i get a reference to
> the newly created copy of this sheet?

--

Dave Peterson

in VBA Sheets("mysheet").Copy Before:=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 _
before:=.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 Before:=Sheets(1) how do i get a reference to
> the newly created copy of this sheet?

--

Dave Peterson