Hi,

I've written a macro to autofilter on a particular column of a worksheet.
Now i need to get the count of filtered rows (no. of visible records). I'm
not sure how to use the 'Count' property of autofilter. I've written a code
block to do this work for me which consumes a lot of time.

ActiveSheet.Range("$A$1:$AX$5000").AutoFilter Field:=FilterColumn2,
Criteria1:=FilterValue2, Operator:=xlFilterValues

TotalNumber = 0

For j = 2 To 5000
If Cells(j, 1) < "" Then
If Cells(j, 1).EntireRow.Hidden = False Then
TotalNumber = TotalNumber + 1
End If
Else
Exit For
End If
Next

Is there a way to get the count by using count property rather than using
the above code block?

Many Thanks,
Vinoth