On a blank sheet set cell A10 to the value of 10.
Give cell A10 a name of “ABC”, but then edit that definition removing the sheet component so that the name ABC applies to all sheets. i.e. The range is just “$A$10”
Referencing “ABC” now yields the value 10. So far so good.
Now delete row 1 through 3.
Cell A7 now contains the 10 and referencing “ABC” yields a null cell.
How can I get the name “ABC” to automatically refer to cell A7 the instant the 3 rows are deleted? It appears that once a name is created, it is an absolute reference to the position and inserting row / columns or cut & paste will not relocate the name.
Is there a way to have the name relocate to cell A7 in my example?