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 attributes of the rows being displayed. The formula updates dynamically as the filter is changed.
It would be helpful at times to also display what the current filter criteria are.
Is there a way to interrogate the AutoFilter for the current criteria?
I have not found a method for this.