Why not simply copy the sheet you want duplicated, or create a worksheet
template?
http://www.ozgrid.com/Excel/excel-wo...-templates.htm
it sounds like what I want to do is not possible.
I doubt it, but you will HAVE to detail exactly what you are trying to do.
--
Regards
Dave Hawley
www.ozgrid.com
"ysam4440" wrote in message
...
Hi
the macro insets a new sheet then copies another sheet onto it. i then
rename the sheet. when you try to do this again the macro looks for the
original sheet number and overwrites the information in it. it sounds like
what I want to do is not possible.
"Gord Dibben" wrote:
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.
.