Try it this way...

Sheets(ProjectSummaryTemplateSheetName).Copy Befo=ActiveSheet

--
Rick (MVP - Excel)


"John" wrote in message
...
What code do I execute to find the Worksheet number associated with the
currently selected worksheet? I have a macro that creates a new worksheet
before sheet1 by copying a template sheet using:
Sheets(ProjectSummaryTemplateSheetName).Copy Befo=Sheets(1)
I'd like to place it right before the selected worksheet.