When I use AutoFilter on a worksheet I often put a row above the filter to
show how many rows are displayed or some other formula that updates
dynamically as the filter is changed.
It would be helpful at times to display additional information such as the
current filter criteria.
Is there a way to interrogate the AutoFilter for the current criteria?
I have not found a method for this.