Hi,

I have a problem filter in macro. Any help would be much appreciated
this is my code:

ActiveSheet.Range("details").AutoFilter Field:=30, Criteria1:="USD", Operator:=xlAnd, Field:=12, Criteria1:=">5000000", Operator:=xlOr
ActiveSheet.Range("details").AutoFilter Field:=30, Criteria1:="EUR", Operator:=xlAnd , Field:=12, Criteria1:=">7000000", Operator:=xlAnd

How can I make a correct filter?

Thank you