discogs
asked on
true row count of filtered range
Hi there,
In excel 2010 I have a filtered range called data. When I filter it using criteria, I want to return the true row count of only the visible cells or filtered results.
Does anyone have any idea on how I can do this with vba?
TA
In excel 2010 I have a filtered range called data. When I filter it using criteria, I want to return the true row count of only the visible cells or filtered results.
Does anyone have any idea on how I can do this with vba?
TA
ASKER
Hi thanks for your answer.
I am trying to integrate this into a vba function that does other thing.
That said, I was more looking for something like:
TA
I am trying to integrate this into a vba function that does other thing.
That said, I was more looking for something like:
MyTrue Count = Intersect(.SpecialCells(xlCellTypeVisible), .Range(.Rows(2), .Rows(.Rows.Count)))
TA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! That's exactly what I was looking for..
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
like =SUBTOTAL(2,your_range)