How to check for Range Name errors, unused Names and hidden Names

Range Names can be extremely useful. They can also be a mess if not well maintained.

We make extensive use of Range Names for model automation and for things like Standard Monetary Unit where it doesn't make sense to call up the ingredients.

There's no doubt that they are useful. But they can also become a mess as things are deleted in the model or content is pasted in, for example.

This report will list all the Range Names in your model and show you any errors or unused names.

The report will tell you:

  • All the Range Names in the model
  • Whether they are visible or not
  • Which cells do they refer to
  • The values they contain
  • How often are they used in formulas
  • References to the formulas they are used in

Here's how to get the report and how to use it.

This post is for subscribers only

Already have an account? Sign in.


Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.