Is there any way to tell a macro that when a new sheet is added what the
sheet name is instaed of having Excel just give it the next "sheet1"? Other
functions in the macro reference the newly created tab and I'll never be able
to ensure it is ALWAYS "sheet1" before running the macro. I would like to
have the macro automatically give it a name I designate.

"Sheets.Add" is the function.

Any ideas??
Frank