All of the following are advantages to using named ranges over direct cell references except

The cells included in a named range can be changed and these changes will immediately apply to anywhere the name is used.

Named ranges make formulas more readable than using direct cell references.

Named ranges are easier to reference because you can type a name instead of a cell.

Named ranges allow for relative references that update the referenced cells as you fill down a column.