List of all ranges defined for a sheet
We have been using a lot of cross sheet links and need to clean things up.
Is there a way to see all the named ranges used to access data in a sheet? In other words, show all the ranges and thus the sheets, that are using data from the current sheet?
Help Article Resources
Check out the Formula Handbook template!