T. Valko said:
I think I may have misunderstood your question!
You use INDIRECT to make it robust against row insertions.
This will work:
ROW(1:10)
However, if you insert new rows above or within the range the formula will
break. For example, if you inserted a new row 1 the ROW(1:10) becomes
ROW(2:11). Using INDIRECT accounts for row insertions. ROW(INDIRECT("1:10"))
will *always* refer to 1:10.
