how to save worksheets in another excel file?

[Charlize]

charlize it gives me debug that :"cannot rename the sheet to the same name as another sheet, a refrenced object library or..."

Of course, you'll have to check if the name that you want to add, already exists. If so, you could add the data of the current workbooksheet to the copytoworkbooksheet and skip the creation of the sheet otherwise create and copy.

Charlize

[Norie]

The code I posted saves into a new workbook.