This is not the way to do this. You should convert your range to a "table". Use the menu item "insert\table". Tables are designed to solve this issue (among other things)