sorting rows containing named ranges

When I sort by rows containing some cells having a range name, the data moves but the named ranges stay put in the same absolute cell position, now referring to the wrong data. How do I get named ranges to move with the data during the sort? Thanks

Hi,

Make sure there are no empty coloumns between the names and the data. Other wise, post your sheet so we can see it and figure out the problem