asmenut,

There is an "After" option, too:

ActiveSheet.Copy After:=ActiveSheet

HTH,
Bernie
MS Excel MVP

"asmenut" wrote in message
...
I have a workbook that contains 5 sheets. From time to time the user will
need to add a sheet after the active sheet.

I know that there is a "Before" option, but is there a way that I can code
(VBA) a way to insert the new sheet "After" the activesheet?