Hi Mark,

You can also specify where you add the sheet so you already know the
position. And I have a hinkering that this delves deeper than just knowing
the Index of the sheet. Am I right?

Anyway, examples ...

Add a sheet as the first sheet:
Sheets.Add befo=Sheets(1)

Add a sheet as the last sheet:
Sheets.Add after:=Sheets(Sheets.Count)

HTH
--
Regards,
Zack Barresse, aka firefytr

"mark kubicki" wrote in message
...
after command: Sheets.Add
is there a simple way of determining the number of the sheet just added?

-as always, thanks in advance
mark