Insert A Worksheet using VBA

[Mike]

I have a workbook that I need to add a Worksheet called "CurWorkPad" to.

Right now I can insert a worksheet and it will come up named "Sheetx", where
x=a number that increments each time a sheet is inserted. I also have code
to rename a worksheet, but it requires you to know the current name of the
inserted worksheet.

Is there a way to insert a new worksheet and rename it at the same time
without knowing what excel named the new worksheet?

Thanks for any help.
Mike

 

[Sloth]

when you insert the worksheet the new worksheet becomes selected
automatically, so you can use this to rename the new sheet

ActiveSheet.Name = "New_Name"

 

[Mike]

Worked Great. Thanks.

Mike

Try this

Sub addsheet()
Sheets.Add.Name = "CurWorkPad"
End Sub

change " curworkpad" to any name you want

 

[flow23]

Try this

Sub addsheet()
Sheets.Add.Name = "CurWorkPad"
End Sub

change " curworkpad" to any name you want