AutoFilter question/help

[redspanna]

Hi all,

I have the following code within my VB to filter fields 2 & 5 as shown

ActiveSheet.Range("$A$2:$O$517").AutoFilter Field:=2, Criteria1:="T5"
    ActiveSheet.Range("$A$2:$O$517").AutoFilter Field:=4, Criteria1:="=arr", _
        Operator:=xlOr, Criteria2:="="

I want to add a thrid filter to same range that will filter field 1 to the date that populates cell A13 in 'Daily Total' sheet

I had this code

ActiveSheet.Range("$A$2:$O$517").AutoFilter Field:=1, Criteria1:=Sheets("Daily Total").Range("A13").Value

but can't seem to get it to work

any help / ideas

many thanks

 

[Andrew Poulsom]

Maybe try:

ActiveSheet.Range("$A$2:$O$517").AutoFilter Field:=1, Criteria1:=CLng(Sheets("Daily Total").Range("A13").Value)