You cannot name a sheet same as another so you must check to see if that
sheetname exists then add a sheet with an alternate name.

Post the code you have tried.

What pattern of name would you want?


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 17:02:01 -0700, ysam4440
wrote:

howdy
i want a macro to insert a worksheet then name it. when i try to do this
with a second worksheet the macro overwrites the first worksheet

"FSt1" wrote:

hi
no. the sheet number is how excel keeps track of everything. even if you
change the name of the sheet to a non-number name, excel still keep the sheet
number in the background.
but people have aways gotten around this problem with macros. what problems
are you having?

Regards
FSt1

"ysam4440" wrote:

is there any way of inserting a worksheet that does not have a sheet number
on it. would be handy for using in macros.