Unchanging array formulas
Posted by Brian on November 10, 2001 6:07 AM
I am trying to find out if it is possible to keep a
cell range in an array formula from changing.
Here is the formula:
I set this up for someone who is a habitual row deleter
and every time a row gets deleted from the CON sheet
it changes this formula's range numbers. (This formula
is on another sheet.)
Is there any way to make the range always point from
2 to 400 whether or not rows are added or deleted?
Any help would be greatly appreciated.