Forum Discussion
FORMULA Ranges keep changing even if I used a Named Range
I have been having issues with ranges changing even when they are fixed $A$7:$A$1600. So I created named ranges in the Name Manager. However, I am seeing those values change after releasing it to t...
If you have a named range that refers to =PI_Package!$A$7:$A$1605, that range will shift if the user inserts or deletes cells above A7. To ensure that the named range will always refer to A7:A1605, make it refer to =INDIRECT("PI_Package!A7:A1605")
Since INDIRECT takes a string argument, it it not affected by cells being inserted or deleted.
HansVogelaar thanks Hans. That is indeed what I did and it seems to work well.