Find the range of a SubTotal
Is it possible to find the range that a SubTotal function refers to?
i.e. cell value is "=SUBTOTAL(9,J25:J31)"
Within the macro I want to determine the range of rows referred to in this cell (25-31).
--
Regards;
Rob
------------------------------------------------------------------------
|