Add and name new worksheet

[DaveE]

I have added a new sheet using ActiveWorkbook.Sheets.Add After:=ActiveSheet but cannot find the method of naming the new sheet.
Can someone please help

[shg]

The new sheet becomes the active sheet, so

activesheet.name = "Bob"

Please be mindful of using code tags.

[rylo]

Hi

Try this

With ActiveWorkbook.Sheets.Add(After:=ActiveSheet)
    .Name = "yourname"
  End With

rylo

[DaveE]

Thanks for your help
You have done in two minutes what I couldn't find in two hours
Thanks again