Apply Names

This video shows how to ensure that if you create range names, they will show up in previously created formulas.

These are the two files needed to follow along to this video:

APPLY NAMES START

APPLY NAMES FINISH