How to use Criteria1:="" to NOT TAKE multiple criteria

[anzer]

Hello,

So I have set 3 dates like this in excel:
Dim TradeDate As Range
Set TradeDate = ActiveSheet.Range("AA1")
Dim TradeDate1 As Range
Set TradeDate1 = ActiveSheet.Range("AB1")
Dim TradeDate2 As Range
Set TradeDate2 = ActiveSheet.Range("AC1")

Then I have a pivot table with thew date on column 4 and I am trying to filter OFF those date
With one date it is easy as I can just put:
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=4, Criteria1:="<>"TradeDate
but it does not work with multiple criteria so I tried something like this and still not working

Selection.AutoFilter Field:=4, Criteria1:"<>" Array( _
TradeDate, TradeDate1, TradeDate2), Operator:=xlFilterValues

Any idea on what is wrong with the code?

Thank you

 

[anzer]

[FONT=&quot]Also, for the Pivot Table I need the results with the TradeDate, TradeDate1 and TradeDate2 so now I am using this code when I need those date[/FONT]
[FONT=&quot]Range("A1").Select[/FONT]
[FONT=&quot]Selection.AutoFilter Field:=4, Criteria1:=Array(TradeDate, TradeDateMoins1, TradeDateMoins2), Operator:=xlFilterValues[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]But I just need to figure out how to filter them out for the next step[/FONT]