I have a named range of
When the row is shifted up in a later routine this range will change to
I need it to stay as the original. I have no idea why this is working like this.
I've tested your issue and for me it happens only if I delete
'Student Information'!$B$8, and that's the expected behaviour.
If I delete column A or rows 1:7, then reference changes accordingly (e.g. after deleting column A it becomes
If you delete the referenced cell Excel doesn't know where do you want the new reference to be (if you want it at all), so it gives you error.
As a workaround you can use
This will always refer to B8 regardless of the changes.