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?