Macro Autofilter with 2 field

[tiii]

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

[humdingaling]

Autofilter does not work that way
if you tried to do that manually you wouldnt be able to do that

you need to either use a helper column to identify what to filter

=OR(AND(AD2="EUR",L2>7000000),AND(AD2="USD",L2>5000000))

or use an advanced filter
http://www.contextures.com/xladvfilter01.html