LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default Named range list

I know that I can generate a list of all my named ranges using Insert-
Name-Paste, which lists the names and the ranges to which those

names refer.

Rather than using Insert-Name-Define to edit what a range refers to,
in a spreadsheet with more than a few named ranges it would be useful
to be able to go back the other way from the pasted list ie edit the
range in the list and then update from that list.

I've played around a bit and thought that "Create" might do the trick
but alas no. Is this at all possible?

Thanks and regards

Murray

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
List Box - For Input Range can I use named range in another workbo dim Excel Worksheet Functions 2 January 3rd 08 06:10 PM
Multiple instances of a named range, not in the list DaveO[_2_] Excel Discussion (Misc queries) 4 April 16th 07 10:34 PM
inserting a named range into new cells based on a named cell Peter S. Excel Discussion (Misc queries) 1 June 4th 06 03:53 AM
Using a data validation list to look up a defined named range in another worksheet Laura Hunt Charts and Charting in Excel 0 November 24th 05 02:29 PM
How can I use a named range for "pick from drop-down list"? InstantZen Excel Discussion (Misc queries) 7 May 24th 05 12:51 AM


All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"