I have a workbook where one sheet is linked to another. I have a formula
that references a range similar to A1:A500. But whenever I delete rows from
the sheet that this formula is linked to it changes the reference to
something like this A1:A492. I would like to be able to force this range to
always stay the same no matter what.