inserting a worksheet
in [General]
|
Prev: VB code
Next: Track Changes Colour
From: ysam4440 on 7 Apr 2010 22:48 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 > <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 23:07
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. -- Regards Dave Hawley www.ozgrid.com "ysam4440" <ysam4440(a)discussions.microsoft.com> wrote in message news:4EDA3D98-73E0-475A-9516-6AAF8E217778(a)microsoft.com... > 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 >> <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. >> >> . >> |