V
Vinoth
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
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