Excel VBA autofilter between percentages

Viewed 842

I want to get the total number of rows where the density percentage is more than 60% but less than 90%.

I am doing this through VBA to add filters on density column (percentage format):

With ActiveSheet
        .AutoFilterMode = False
                With .Range("A3:EB3")

                     .AutoFilter
                     .AutoFilter Field:=98, Criteria1:=">9"
                     .AutoFilter Field:=99, Criteria1:=">2014"
                     .AutoFilter Field:=23, Criteria1:=">60%"
                     .AutoFilter Field:=23, Criteria1:="<90%"

                End With
    End With

But auto filter displays no rows

1 Answers
Related