Create Copy of Current Worksheet

  • Thread starter Thread starter Birdy92
  • Start date Start date
B

Birdy92

I am looking for a way to create a copy of the current active worksheet using a
macro.


Is there a way to do this by telling the macro, make a copy of this current
"active" worksheet. I know how to do this by making a copy of an original
"master" worksheet, but I want update the "active" worksheet that never has the
same name.
 
Where do you want the copy? In the same workbook or a new workbook?

activesheet.copy 'will copy it to a new workbook.

or

Activesheet.copy _
after:=activesheet
'now the copied sheet is active
activesheet.name = "NiceUniqueNameHere"

will copy it right after itself and rename it.
 
Back
Top