naming sheets

  • Thread starter Thread starter ranswrt
  • Start date Start date
R

ranswrt

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
 
You should ALWAYS post YOUR code for comments.
next line
activesheet.name="newname"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add sheet and name it unless it already exists 12
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Copy adjacent Sheet and name from a list 42
If named sheet exists then delete it 9
Is it possible after creating a new sheet to insert code in it? 9
Automatically Adding a Worksheet 14
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Name of Added Worksheet 9

Back
Top