Does anyone know how to prevent Excel from changing a named range
when an included row is deleted (or added)? What I have is;
Data =Sheet1!$B$1:$U$10
and if I delete row 3, it changes to:
Data =Sheet1!$B$1:$U$9
I would like for it to not change at all…..
Thanks…. Robbie