Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overview usage named ranges
Hi,
currently I'm cleaning up a quite extensive workbook in which named ranges have been used. Is there any way to have an overview of the usage of named ranges in order to support actions like remove named ranges that haven't been used, detect 2 overlapping ranges (maybe different name for same range) etc. Is there any support at all for this ? If not standard provided, is there a way through programmation which I can use ? Tnx, Kind regards, Bart |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overview usage named ranges
Get hold of Jan Karel Pieterse's (FREE!) NameManager addin, it will do what
you want and lots more http://www.jkp-ads.com/Download.asp -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bart Wouters" wrote in message ... Hi, currently I'm cleaning up a quite extensive workbook in which named ranges have been used. Is there any way to have an overview of the usage of named ranges in order to support actions like remove named ranges that haven't been used, detect 2 overlapping ranges (maybe different name for same range) etc. Is there any support at all for this ? If not standard provided, is there a way through programmation which I can use ? Tnx, Kind regards, Bart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
[Shift] + [Arrow] key usage with chart ranges | Excel Worksheet Functions | |||
3D Named Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |