Filter on top 20

D

dk

MrExcel MVP

Joined

Feb 15, 2002

Messages

2,942

• Mar 13, 2011

• #2

You haven't named the first argument and the Field argument should be numeric, not a string. Something like this should work:

Code:

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

 

Upvote 0

Z

zabiullakhan

Active Member

Joined

Aug 30, 2010

Messages

310

• Mar 13, 2011

• #3

Thanks a lot it works..

However i am not geting exact 20 when i filter on 2 to 3 col and take top 20. I guess i need to take top 20 visable fields.


Please help.

 

Upvote 0

Z

zabiullakhan

Active Member

Joined

Aug 30, 2010

Messages

310

• Mar 13, 2011

• #4

If I filter 3 col before i take top 20 then i dont get top 20 rows, if i just take top 20 i get exact 20 row.

Can u please help me to filter on the 3 columns and then take exact top 20..
Please help

 

Upvote 0