I would like to ask if there is a way to update the range specified in a macro when I insert/delete cells.
For example, I have specified the range in a subroutine in my macro to be
Worksheets("Query Screen").Range("M22:M25") = "0"
Now, if I insert a new row between
M25, what can I do to update the range in my macro automatically to be
Worksheets("Query Screen").Range("M22:M26") = "0"
Thus, is it possible to update the macro based on changes in the Excel spreadsheet?