I have macro code to activate filter:
Essentially value in the range is the number want to display... an error (# REF!) are hidden![]()
Columns("F:F").Select Selection.AutoFilter ActiveSheet.Range("$F$1:$F$421").AutoFilter Field:=1, Criteria1:=Array("0", _ "10", "106", "113", "140", "150", "2", "225", "30", "305", "34", "38", "515", "76"), _ Operator:=xlFilterValues
How to write Filter criteria code as above..
thanks in advance
Bookmarks