You can make them dynamic so they are self adjusting using OFFSET or match
or ....
=offset($a$1,0,0,counta($a:$a),5)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JFU" wrote in message
...
My application requires adding records (rows) on an ongoing basis, then
sorting on column A (Category). How do you get named ranges to update to
their new location after sorting? If I manually move a row, the
referencing
hyperlink follows. However a data sort does not update the name pointer
and
I have to go in and edit the range.