SOLVED adding worksheets

I recorded the following macro:

Code:

---

Sheets("Sheet2").Select
Sheets.Add
Sheets("Sheet2").Select
Sheets("Sheet2").Name = "name"

---

The problem is that I'm going to be adding multiple sheets. Which brings me to my question: How can I change the name of the sheet that I just added?

Thanks,
Alex

Excel keeps track of the active worksheets in a workbook within a worksheets collection. One property of this collection is count which you can use to help you here:

VB Code:

Worksheets.Add After:=Worksheets(Worksheets.Count)
Worksheets(Worksheets.Count).Name = "MyNewSheetName"

Here I'm saying "add a new worksheet after the last existing one in this workbook, then go to this new last sheet I just created & change it's name..."

works :)

Thanks