in VBA Sheets("mysheet").Copy Before:=Sheets(1) how do i get a reference to
the newly created copy of this sheet?
in VBA Sheets("mysheet").Copy Before:=Sheets(1) how do i get a reference to
the newly created copy of this sheet?
Hi Daniel,
Try something like:
Dim WB As Workbook
Dim WS As Worksheet
Set WB = ActiveWorkbook
With WB
.Sheets("Mysheet").Copy Before:=.Sheets(1)
End With
Set WS = ActiveSheet
---
Regards,
Norman
"Daniel" <[email protected]> wrote in message
news:[email protected]...
> in VBA Sheets("mysheet").Copy Before:=Sheets(1) how do i get a reference
> to
> the newly created copy of this sheet?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks