LinkBack URL
About LinkBacks
Hi,
Let's say I have a sheet called SheetX and I would like to make a copy of it and name it SheetXX.
How do I code that?
Thanks in advance!
Hi,
Let's say I have a sheet called SheetX and I would like to make a copy of it and name it SheetXX.
How do I code that?
Thanks in advance!
Last edited by moomphas; 12-08-2015 at 07:15 AM.
I figured it out in meantime. In case anyone needs it:
Dim ws1 As Worksheet
Set ws1 = ThisWorkbook.Worksheets("SheetX")
ws1.Copy ThisWorkbook.Sheets(Sheets.Count)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks