is there any way of inserting a worksheet that does not have a sheet number
on it. would be handy for using in macros.

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.

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.

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.

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.

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.

.

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.

.