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.



Birdy92 wrote:

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.

--

Dave Peterson