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
|