Hi Adri

Can you give example

If the name already exist the on error will avoid a error
and the sheet will not be named for example

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Adri" wrote in message ...
I use the macro "Testfile(6)" form http://www.rondebruin.nl/copy3.htm.
It copies the first sheets coorrect. The macro also should rename the sheet
the same as the workbook name.
Some names are correctly renamed, others not.
What causes this and how can I fix it?

--
Kind regards
Adri