troubleshooting Question

Count number of rows populated by an autofilter in excel.

Avatar of Saurabh k
Saurabh k asked on
VBAMicrosoft ExcelMicrosoft Office
4 Comments3 Solutions104 ViewsLast Modified:
team       subteam       user             priority
T              t2                       u1                1
T              t2                       u2                1
T              t2                       u2                1
T                 t2                       u2                1
T             t2                       u1                1
T            t2                       u1            1
T            t2                       u2                1
T             t2                       u1                1
T            t2                       u1                1
T              t2                       u2                1

consider above data I get by applying an autofilter for priority 1 for users u1,u2 belonging to team 2, what I need is a count of the populated rows in column ''priority'' in Excel VBA code. I tried using Subtotal function but I don't want the count generated via subtotal function.
Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros