You should ALWAYS post YOUR code for comments.
next line
activesheet.name="newname"
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ranswrt" wrote in message
...
I use the code 'sheets.add' to add a sheet to my workbook. How do I then
write a code to name the sheet that was just added?
Thanks