In a spread sheet i have several named ranges, i need to clairfy the following:
1. Is there a feature in excel where i can look at the various name ranges, and in that i can findout the sheet and cell range the name range refersto
2. Can a macro be provided to me where by it will in a new sheet list all the name ranges in column A and then in column B it will list the sheet name it refers to and in column C it will list the cell range.
If there any other special conditions for the name ranges then these can also be referred to in the columns adjacent tot he name range.