[dba-Tech] Excel -- dynamic range name

The only way I know of to create a dynamic range name when the list of items
increases/decreases is to create a range name that's one cell more than
needed and insert a row before adding a new record -- that stretches the
range to include the new row. 

Is this the best way? 

Susan H.