Beyond SUBTOTAL()

Overview

This collection of posts deal with discoveries about the SUBTOTAL() worksheet function and some means to improve it by replacing it...and some ancillary thoughts.


The Posts...to date

Post to be developed

Defining a Range by the Functions in Cells

This post no longer deals directly with the replacement of SubTotal(). Named ranges are wonderful things, but keeping them up-to-date adds to maintenance and development overhead.  They are referenced in the above and while writing the other posts I realized there are times with we make an entry into a worksheet and we need to expand or contract the scope of a named range.

This post, still in draft form, puts forth the idea that when a cell is updated the event model can be exploited to add/remove the changed cell to/from a Named range, typically scoped to the worksheet.