After partitioning, have a function to re-index row, col and address relative to the origin (top-left cell) of each partition.
Have a way to refer to a range, scoped to the partition or sheet. R1C1 notation might be the most useful, especially if extended to use negative numbers to refer to positions relative to the final row and column of a partition or sheet.
After partitioning, have a function to re-index
row,colandaddressrelative to the origin (top-left cell) of each partition.Have a way to refer to a range, scoped to the partition or sheet. R1C1 notation might be the most useful, especially if extended to use negative numbers to refer to positions relative to the final row and column of a partition or sheet.