how do I get the name of worksheet I just add in macro
 

In macro, I use sheets.add create a new worksheet. I need
to know the name of the worksheet I just created. how can
I do it?

how do I get the name of worksheet I just add in macro
 

Dim sh as Worksheet
set sh = Worksheets.Add
msgbox sh.Name

--
Regards,
Tom Ogilvy



"jane" wrote in message
...
In macro, I use sheets.add create a new worksheet. I need
to know the name of the worksheet I just created. how can
I do it?