after command: Sheets.Add
is there a simple way of determining the number of the sheet just added?

-as always, thanks in advance
mark

when you add a sheet it's autom. activated..
the "number" is given by the Index property

Activesheet.Index

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


mark kubicki wrote :

after command: Sheets.Add
is there a simple way of determining the number of the sheet just
added?

-as always, thanks in advance
mark

You could always do

Woksheets.Add.Name ="mySheet"

and you have its name

--
HTH

Bob Phillips

"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

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