Naming a newly added sheet
 

Try something like

Worksheets.Add.Name = "The Name"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Dr. Schwartz" <Dr. wrote in
message
...
If I add a new sheet to my workbook with sheet.add Excel names
the sheet.
However the name depends on how many other sheets the workbook
contains.

Does anyone know how to add a sheet and name right away