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

[jane]

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?

 

[Tom Ogilvy]

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