oXL.WorkSheets(n).Name = cName.

>Hi,
>I am creating number of worksheets using the command:-
>
>oXL.SheetsinNewWorkbook = 4
>
>
>Can we set a different name for each worksheet and how.
>
>
>Best Regards
>Issam Mansour