Request help with Non-Volatile Static Reference

[mrblister]

Hi,

I have a formula, which contains the formula component "Row($1:$50)". When I insert a new row at the top of the sheet, the reference becomes "Row($2:$51)" which messes-up my formula. Is there a Non-Volatile way to maintain the $1:$50 if I insert a row at the top of the sheet? Would rather not use Indirect or other Volatile functions.

Thanks!

 

[Peter_SSs]

Try
=ROW(INDEX(A:A,1):INDEX(A:A,50))

 

[mrblister]

Try
=ROW(INDEX(A:A,1):INDEX(A:A,50))

Thank you!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.