If your range is held within a variable, it will not be saved.

But, I managed to get around this. Put your variable in an empty cell
of the spreadsheet, and then make your sub look at this cell at the
begining and reassign the value of the cell back to the variable.