if you use

activeworkbook.Sheets.Add

then the added sheet should become the active / selected one.

Duncan

davegb wrote:

When I add a new worksheet, how do I select it? I don't know which
number it is, since I don't know how many sheets there are. Do I have
to count the sheets to find out how many there are, then add the
worksheet and select the next number higher than the count?
Thanks for the help!