Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|