counting filters?

  • Thread starter Thread starter xXx
  • Start date Start date
X

xXx

I have used a auto-filter and want to count how many rows i have stil
remaining
 
You can count the visible rows:

http://www.contextures.com/xlautofilter03.html#Count

'========================
Sub CountVisRows()
'by Tom Ogilvy
Dim rng As Range
Set rng = ActiveSheet.AutoFilter.Range

MsgBox rng.Columns(1). _
SpecialCells(xlVisible).Count - 1 _
& " of " & Range("A1").CurrentRegion _
.Rows.Count - 1 & " Records"

End Sub
'============================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using formulas along with Auto Filters 1
Getting the count from autofilter 2
Filter and count hidden cells problem 2
Count Number of Visible Rows in Filtered View 2
Problem with code 2
Code Snippet - Data Filter 8
Multiple or nested AdvancedFilters? 1
How to get the count of filtered rows after applying autofilter? 2

Back
Top