I'm trying to create a new worksheet with a macro where the worksheet has a
specific name. However, when the macro creates the worksheet, it creates one
with the name "SheetXX". I can continue the macro to rename "SheetXX" to the
specific name I want, but captured in the macro is referenece to "SheetXX".
When I run the macro again, it creates a new worksheet with the name
"SheetXX+1" and then bombs out because it can't find "SheetXX" to rename it
to the specific name that I want.
Anyway to to have the macro create the new worksheet with the specific name
without having to have the Excel generated "SheetXX" name and then having to
rename it to the specific name?
Thanks for your help.
Steve Krieger