Defining a Named Range assigns a name to the range. The range can be
manually changed based on a selection. However, when you try to record the
steps up update the range of an existing Name, the range is hardcoded in the
macro. Running the macro does not update the Named range.

I am using the Named ranges in other macro's, e.g., selecting and copying
data in the range, creating a pivot table based on the range.