Hello,

I get an error if the workbook already contains the
worksheet "myname". How do I title the sheet "myname1" if
it already exists or "myname2" if they both do ... etc.

Thanks for your help.

-----Original Message-----
Hi
try
....
dim wks as worksheet
set wks = worksheets.add
wks.name="myname"

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im
Newsbeitrag
...
Hello

How can I add a new sheet to a workbook using vba and
call
it a specific name (not sheet1). And if that name
already
exist in a sheet for the workbook call it that name + 1.



.