inserting a worksheet
in [General]
|
Prev: VB code
Next: Track Changes Colour
From: ysam4440 on 25 Mar 2010 20:55 is there any way of inserting a worksheet that does not have a sheet number on it. would be handy for using in macros.
From: FSt1 on 25 Mar 2010 22:45 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.
From: ysam4440 on 7 Apr 2010 20:02 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.
From: Gord Dibben on 7 Apr 2010 20:20 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 <ysam4440(a)discussions.microsoft.com> 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.
From: ozgrid.com on 7 Apr 2010 20:49
Sheet insertion will NOT "overwrite" ANY sheet. -- Regards Dave Hawley www.ozgrid.com "ysam4440" <ysam4440(a)discussions.microsoft.com> wrote in message news:E98BF942-EE80-4257-9A84-055CF89525BB(a)microsoft.com... > 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. |