naming sheets
 

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

naming sheets
 

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

naming sheets
 

activesheet.name = "mysheet"

Cliff Edwards