Naming a newly added sheet
 

Hi
try
dim wks as worksheet
set wks = worksheets.add
wks.name="your name"


--
Regards
Frank Kabel
Frankfurt, Germany

"Dr. Schwartz" <Dr. schrieb im
Newsbeitrag ...
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