ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Scope of range names (https://www.excelbanter.com/excel-discussion-misc-queries/52415-re-scope-range-names.html)

Printing of Range Name References

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?




Dave Peterson

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


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com