View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Sheet Copy After:

Hi

Try this

Worksheets.Add after:=Worksheets(ActiveSheet.Index)


--
Regards Ron de Bruin
http://www.rondebruin.nl



"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?