Y
ysam4440
is there any way of inserting a worksheet that does not have a sheet number
on it. would be handy for using in macros.
on it. would be handy for using in macros.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
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
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
Y
ysam4440
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
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
G
Gord Dibben
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
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
O
ozgrid.com
Sheet insertion will NOT "overwrite" ANY sheet.
Y
ysam4440
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.
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.
O
ozgrid.com
Why not simply copy the sheet you want duplicated, or create a worksheet
template?
http://www.ozgrid.com/Excel/excel-worksheet-templates.htm
RE: 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.
template?
http://www.ozgrid.com/Excel/excel-worksheet-templates.htm
RE: 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.