Eliminate area ranges on a spreadsheet
 

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

Eliminate area ranges on a spreadsheet
 

If you've only got a couple you can do it manually by clicking insert - name
- define and delteing them one by one. If you have a lot then you can use
this macro. Caution, There is no undo.

Sub DeleteallNames()
Dim nName As Name
For Each nName In Names
nName.Delete
Next nName
End Sub

Mike

"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

Eliminate area ranges on a spreadsheet
 

I've eliminated the ranges as suggested & saved the workbook. However, when
I attempt to copy the worksheet, again I get the message: "A formula or
sheet you want to move ore copy contains the name 'xxx', which already exists
on the destination worksheet. Do you want to use this version of the name?"
I must click "YES" or I will be forced to rename the area!
--
Holly


"Mike" wrote:

If you've only got a couple you can do it manually by clicking insert - name
- define and delteing them one by one. If you have a lot then you can use
this macro. Caution, There is no undo.

Sub DeleteallNames()
Dim nName As Name
For Each nName In Names
nName.Delete
Next nName
End Sub

Mike

"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

Eliminate area ranges on a spreadsheet
 

Then it is likely something is creating the named ranges again. Are you
prompted to enable macros when the workbook opens? If so click don't enable
and open the workbook then delete all the ranges manually and try copying. If
this works then I'm you going to have to look in the VB editor to find where
they are being created and stop it.

Mike

"Holly" wrote:

I've eliminated the ranges as suggested & saved the workbook. However, when
I attempt to copy the worksheet, again I get the message: "A formula or
sheet you want to move ore copy contains the name 'xxx', which already exists
on the destination worksheet. Do you want to use this version of the name?"
I must click "YES" or I will be forced to rename the area!
--
Holly


"Mike" wrote:

If you've only got a couple you can do it manually by clicking insert - name
- define and delteing them one by one. If you have a lot then you can use
this macro. Caution, There is no undo.

Sub DeleteallNames()
Dim nName As Name
For Each nName In Names
nName.Delete
Next nName
End Sub

Mike

"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

Eliminate area ranges on a spreadsheet
 

There is no "enable macros" when I open the workbook.
--
Holly


"Mike" wrote:

Then it is likely something is creating the named ranges again. Are you
prompted to enable macros when the workbook opens? If so click don't enable
and open the workbook then delete all the ranges manually and try copying. If
this works then I'm you going to have to look in the VB editor to find where
they are being created and stop it.

Mike

"Holly" wrote:

I've eliminated the ranges as suggested & saved the workbook. However, when
I attempt to copy the worksheet, again I get the message: "A formula or
sheet you want to move ore copy contains the name 'xxx', which already exists
on the destination worksheet. Do you want to use this version of the name?"
I must click "YES" or I will be forced to rename the area!
--
Holly


"Mike" wrote:

If you've only got a couple you can do it manually by clicking insert - name
- define and delteing them one by one. If you have a lot then you can use
this macro. Caution, There is no undo.

Sub DeleteallNames()
Dim nName As Name
For Each nName In Names
nName.Delete
Next nName
End Sub

Mike

"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

Eliminate area ranges on a spreadsheet
 

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

Eliminate area ranges on a spreadsheet
 

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

Eliminate area ranges on a spreadsheet
 

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

Eliminate area ranges on a spreadsheet
 

Yes. I saved the file after deleting the names. I even closed & re-opened it.
--
Holly


"Farhad" wrote:

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