The easiest way I can think of is to Name the ranges (you can use Insert >> Name >> Define, or use the Name box to the left of the Excel Formula bar).
Once you have named the ranges, a person can insert rows (or columns) and the Name will shift to the new position (just like the data will).
I am pretty sure that (will test and report back) that you can simply replace the lines
with something like:
And everything will work just as well as if you had used cell addresses instead of names. Infact, since Names (normally) have Workbook level scope, you would no longer need to reference ws1 vs. ws2. Excel will already know where the range is just from the Name.
Is this the sort of answer you were looking for, or something different?
Bookmarks