I have a list with named range and subtotal (within the list). I need to
sort the list then delete some rows, and resort the list to the original
order. The subtotals are never delted. The problem I have is that named
reference for the range and subtotals change after the list is resorted. Is
there a way I can avoid this issue?