Excel Tips Monster

Named ranges, where are you?

I’m using named ranges all the time. They’re useful because referring to a multitude of inputs in a formula can get confusing. Especially if someone has to understand it later in order to improve it or add to it.

However, once I got my 10-20 named ranges in place, I usually forget about them and find myself looking them up again and again.

Data Pig has found the solution: a small VBA subroutine to highlight all named ranges

But wait, there’s more…

The next step is to click the highlighted cell and get the name of the range