adding a sheet and renaming

[oercim]

Hello. With excel macro, I want to add a sheet and rename the
sheet but the name is not specific, it is a variable. For example,

Sub b()
Sheets.Add.Name = "aaaa"
End Sub

works fine but here , the sheet name is not variable, it is
specific named "aaaa",
However, the below gives error

Sub b()
Dim a As String
a = "aaaa"
Sheets.Add.Name = a
End Sub

What can I do? Thanks alot.

 

[Bob Phillips]

Works fine for me. It will fail if that sheet already exists.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[oercim]

OK. sorry, it works fine for me too. Thanks alot.