Sheet insertion will NOT "overwrite" ANY sheet.
--
Regards
Dave Hawley
www.ozgrid.com
"ysam4440" wrote in message
...
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.