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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
