How do I add and then rename a worksheet using a macro?

[Guest]

When I try to rename a new worksheet in a macro, it will make the worksheet
but will not rename it.............. and gives an error because the new
worksheet has a different sheet number than the one the macro just made....

All I want to do is compile a macro that makes a new worksheet and will
rename that sheet a different name. . . . . . . .

 

[Earl Kiosterud]

Jerry,

The inserted worksheet will be the active sheet after the insert, so after
inserting it, you can write:

ActiveSheet.Name = "New Sheet"

 

[Bob Phillips]

Jerry,

Try

worksheets.Add.name="Bob"

--

HTH

RP
(remove nothere from the email address if mailing direct)