Did you save your file after you deleted all names? or you can save it as
another name to avoid loosing previouse file.

Thanks,
--
Farhad Hodjat


"Holly" wrote:

I want to eliminate the defined names on ALL sheets. I've deleted them via
Insert/Name/Define/Delete. But they are still present when I try to copy the
cleaned sheet! At that point, I receive the "A formula or sheet you want to
move...." message.
--
Holly


"Farhad" wrote:

Hi,

i can not underestand exactly what do you want but if you define the names
privately then you can have the same name in each sheet but remember the name
has been recognized just in the sheet taht you defined the name.
Example:

sheet1!abcd
sheet2!abcd
shhe3 no name

the abcd in Sheet1 just been recognized in sheet 1 and if you want to use
this name in sheet2 or sheet 3 you have to write sheet1!abcd

i hope this works for you

Thanks
--
Farhad Hodjat


"Holly" wrote:

I have a worksheet with "area ranges" specified. Anytime I try to copy the
worksheet, I have to rename the ranges (so as not to duplicate them). How do
I get rid of these named ranges? I have no use for them.
--
Holly