Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Scope of range names
Is it possible to print the range names, other than doing a print screen?
"Frank Kabel" wrote: Hi use the Name Manager addin: http://www.decisionmodels.com/downloads.htm#namemanager and also see: http://www.xldynamic.com/source/xld.Names.html -- Regards Frank Kabel Frankfurt, Germany "David Cawlfield" <David schrieb im Newsbeitrag ... I want to be able to change the scope of a name from global to local, so that I can create new ranges on other sheets in the same workbook with the same name. How can I manage the scope of named ranges inside excel? |
#2
|
|||
|
|||
Scope of range names
That name manager can dump all the names to a new worksheet.
You can print that worksheet if you want. Printing of Range Name References wrote: Is it possible to print the range names, other than doing a print screen? "Frank Kabel" wrote: Hi use the Name Manager addin: http://www.decisionmodels.com/downloads.htm#namemanager and also see: http://www.xldynamic.com/source/xld.Names.html -- Regards Frank Kabel Frankfurt, Germany "David Cawlfield" <David schrieb im Newsbeitrag ... I want to be able to change the scope of a name from global to local, so that I can create new ranges on other sheets in the same workbook with the same name. How can I manage the scope of named ranges inside excel? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create range names ? | Excel Worksheet Functions | |||
Range Names | Excel Worksheet Functions | |||
Excel Range Names | Excel Discussion (Misc queries) | |||
formula to set up dynamic range in names | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |