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