>I'm copying a "template" sheet within a workbook in order to make one sheet for each employee. I want to add a sheet called "Cindy" to the current workbook - either at the end (Sheets(Count)) or after some particular sheet.
>
>I have

lcSheetType = "Monthly"
>lcEmployee = "Cindy"
>oExcel.Sheets(lcSheetType).Copy()

which creates a new workbook and puts a sheet called "Montlhy" in it - but I want it to be in the current workbook! The docs say the syntax I need is

Worksheets("Sheet1").Copy after := Worksheets("Sheet3")

but I can't translate this into anything I can use.
>
>Help is appreciated!

=.Sheets(lcSheetType).Copy(,.ActiveSheet)
.ActiveSheet.Name = lcEmployee

Cetin