By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 149 - =subtotal xl func

The subtotal function is useful during filtering

To get the count of rows showing while filtered use

row_count = [=subtotal(3,A:A)] - 1

the "- 1: will subtract 1 for the heading

Example/