If you change the definition of a range name pointing it to a different range the value of any formula using that range name will be updated automatically to reflect the new definition.

Question

Quizplus · Accepted Answer

When the definition of a range name is changed to point to a different range, any formula using that range name will automatically update to reflect the new range.

If You Change the Definition of a Range Name Pointing