how can i filter top 20 items?

[zabiullakhan]

how can i filter top 20 items from VB code.

Please help

 

[Michael M]

    ActiveSheet.Range("YOUR RANGE").AutoFilter Field:=1, Criteria1:="20", _
        Operator:=xlTop10Items

 

[Peter_SSs]

how can i filter top 20 items from VB code.

Please help

Turn the macro recorder on and do it manually and then you should at least have some starter code.

If you need further help after that, post the code you have so far tell us more about your sheet's layout and data and what went wrong with using the code from the recorder.

 

[zabiullakhan]

i get this error on the second line
"AutoFilter method of range class failed"

GrabAdd = Selection.Address

Selection.AutoFilter GrabAdd, Criteria1:="20", Operator:=xlTop10Items

Please help

 

[Peter_SSs]

You haven't used the syntax suggested and we also don't know what the 'Selection' is, but you need something more like this.

Selection.AutoFilter Field:=3, Criteria1:="20", Operator:=xlTop10Items

Where you need to change the 3 to whatever column of the selection you want the filter to check for the top 20 values.

 

[zabiullakhan]

how to select the visible rows only after filtering and determine the no of rows selected?

i just want to select 10 rows which are visible but after filtering it selects the invisable rows too..

Please help

 

[zabiullakhan]

This works? thanks a lot

i am stuck with this issue.
how to select the visible rows only after filtering and determine the no of rows selected?

i just want to select 10 rows which are visible but after filtering it selects the invisable rows too..

Please help

 

[Peter_SSs]

Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Since you have asked this question elsewhere and the original question here appears to be resolved, I'm closing this thread.

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.