Want to filter >180

[veronica.mam]

Hi, I have a column with data as

0-30

31-60

61-90

91-180

>180.


I am able to filter out all values using VBA but when it comes to ">180", I am not able to select that value as criteria in autofilter.


Can somebody please help me in this !!!!

Thank you.

 

[vijaySharma]

Hi Veronica,


try the code below

[pre]

Selection.AutoFilter
ActiveSheet.Range("$A$1:$B$18").AutoFilter Field:=2, Criteria1:="=>180", _
Operator:=xlAnd

[/pre]
Please make changes to cell referrencing as per your Columns

~VijaySharma

 

[veronica.mam]

Thanks a lot for the Help Vijay !!!! It is working perfectly now !