is there anyway to create a clone of an excel sheet in vba?
 

is there anyway to create a clone of an excel sheet in vba?

Not sure I have understood the question but if you are wanting to use VBA to
create a copy of a sheet then something like this should work:

ActiveSheet.Copy befo=Sheets(ActiveSheet.Index)

Hope this helps
Rowan

"Daniel" wrote:

is there anyway to create a clone of an excel sheet in vba?

Right-click the tab name, select Move or Copy from the menu, select your
target book, and tick the copy checkbox.

--
HTH

Bob Phillips

"Daniel" wrote in message
...
is there anyway to create a clone of an excel sheet in vba?