SOLVED adding worksheets

[LodBot]

I recorded the following macro:

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

[alex_read]

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:

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..."

[LodBot]

works

Thanks