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
Bookmarks