PC Review


Reply
Thread Tools Rate Thread

How do I delete the name for a named range i no longer require?

 
 
Chris Mitchell
Guest
Posts: n/a
 
      23rd Jun 2007
I've tried to delete the name for a named range that I no longer require,
but so far have been unable to do so. The named range is now covered by two
other names. How do I delete the original name?


 
Reply With Quote
 
 
 
 
=?Utf-8?B?Um9uIENvZGVycmU=?=
Guest
Posts: n/a
 
      23rd Jun 2007
Try this:

From the Excel main menu:
<Insert><Name><Define>
Select the offending name from the list
Click the [Delete] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Chris Mitchell" wrote:

> I've tried to delete the name for a named range that I no longer require,
> but so far have been unable to do so. The named range is now covered by two
> other names. How do I delete the original name?
>
>
>

 
Reply With Quote
 
Chris Mitchell
Guest
Posts: n/a
 
      23rd Jun 2007
Thanks Ron.

"Ron Coderre" <(E-Mail Removed)> wrote in message
news:99E6325B-DAC7-4591-A938-(E-Mail Removed)...
> Try this:
>
> From the Excel main menu:
> <Insert><Name><Define>
> Select the offending name from the list
> Click the [Delete] button
>
> Does that help?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "Chris Mitchell" wrote:
>
>> I've tried to delete the name for a named range that I no longer require,
>> but so far have been unable to do so. The named range is now covered by
>> two
>> other names. How do I delete the original name?
>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Named rnage and Add Named Range ryguy7272 Microsoft Excel Programming 5 5th Feb 2010 10:15 AM
How do you delete a named range? =?Utf-8?B?V29ya3NtYXJ0?= Microsoft Excel Discussion 5 14th Apr 2009 08:17 PM
Named range longer than 255 chars Doug Glancy Microsoft Excel Programming 6 4th Mar 2005 12:18 AM
Re: OK -- who else finds they can no longer import a named range using Access 2000/2002 (it was fine using 97) Any solution? david epsom dot com dot au Microsoft Access External Data 0 26th May 2004 02:21 AM
Can't Delete Named Range Ricardo Duran Microsoft Excel Worksheet Functions 1 25th Feb 2004 11:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:11 PM.