Naming a new sheet.
 

I am adding a new sheet and trying to name that sheet.
I can add a sheet and i can name a sheet using vba
But when i try to do them together it doesn't work.
I can add a sheet. Then i have to fugure out what it is named and then i
can change the name. Is there a simplier way to add a new sheet to a
workbook and change the name?

Naming a new sheet.
 

One way:


ThisWorkbook.Worksheets.Add.Name = "myname"


In article ,
"Rich Cooper" wrote:

I am adding a new sheet and trying to name that sheet.
I can add a sheet and i can name a sheet using vba
But when i try to do them together it doesn't work.
I can add a sheet. Then i have to fugure out what it is named and then i
can change the name. Is there a simplier way to add a new sheet to a
workbook and change the name?