Help with simple copy worksheet macro

[davidrias]

Here is my code:

ActiveWorkbook.Sheets(Titer).Copy after:=ActiveWorkbook.Sheets("Titer")

This is linked to a worksheet button. If I hit the button, the worksheet is copied, named "Titer (2)" and placed after the original. If I hit the button again, "Titer (3)" is created and placed after the original worksheet. I want the new copy to always be placed after the last copy, i.e. I want "Titer (3)" to be placed after "Titer (2)" and not after "Titer".

I was thinking this might need a for next loop, but I am not sure if that is right.

[davidrias]

Never Mind I got it....

ActiveWorkbook.Sheets(Titer).Copy after:=ActiveWorkbook.ActiveSheet