AutoFilter Failing

[Ark68]

My autofilter is not doing what I was hoping it would ...

With ws_rmrsource
        With .Range("A2:A900")
            .NumberFormat = "yy-mmm-dd"     ' optional to set the display format
            .Value = .Value
        End With
        'sc = CDate(inq_date)
        .Range("A1").AutoFilter Field:=1, Criteria1:="<>inq_date"
  End With

I am trying to filter the data in column A of worksheet ws_rmrsource of all values OTHER THAN the value of inq_date. The visible data should expose the rows of data where the value in A = inq_date.

Column A are true dates finally, and inq_date is a serial number of a date.

I don't receive any errors, the column headers have the drop downarrows, and the row leters are blue (indicating filtered data), yet all rows are exposed includibg those equal to inq_date.

Thoughts?

 

[MARK858]

Try

Criteria1:="<>" & inq_date

 

[Ark68]

Perfect!! Thanks Mark, appreciated.

 

[MARK858]

You're welcome.