Sustaining Range Definitions in a Function
try
Indirect("A1:A500")
"hoftenkrabb" wrote:
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.
|