VBA to insert new sheets at the last position

[Faridwahidi]

Hi,

What went wrong with this code? I want the new sheets to be placed at the last sheet of workbook

Please Login or Register  to view this content.

[JieJenn]

Inside the bracket.

Sheets("NEW SCORECARD").Copy after:=Worksheets(ActiveWorkbook.Sheets.Count)

[Faridwahidi]

Hi JieJenn,

Thanks a lot.

[naveenmarapaka]

Hi.
Try

Please Login or Register  to view this content.

regards

[Faridwahidi]

Hi Naveen,

Thanks. It was resolved

[Alf]

If you want an identical sheet like "NEW SCORCARD" and copy it your new sheet will be named ("NEW SCORCARD (2)") since a sheet name must be unique in a workbook. You can then change the name to somthing more sutable i.e.:

Please Login or Register  to view this content.

Alf