Set an object variable to the sheet when you add

Set newSheet = worksheets.Add

then refer to the object thereafter, rather than activesheet or other such

newSheet.Name = "Bob"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"davegb" wrote in message
oups.com...
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!