Copy Active Worksheet

[chris100]

Hi all,

I just need to copy the active worksheet and paste in the same workbook then activate that new sheet. I know how to do this manually but i need the code to copy the sheet without referencing the actual name of the sheet (because the name of the activesheet willl obviously depend on which sheet i'm on).
I tried recording the macro but this obviously returns the sheet name as part of the code - which is not quite what i want for subsequent sheets.

Hope this is clear and if anyone wcould rustle up an answer before 3am tomorrow morning (it's 10.30here) i would really appreciate it.

thanks a bundle,
Chris

[chris100]

Just figured out how to do this by piecing together a couple of other lines from different places:

Sub Macro1()

ActiveSheet.Select
ActiveSheet.Copy before:=Sheets(1)
Application.Run "RefireBLP"

End Sub