Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,562
- Office Version
- 365
- 2016
- Platform
- Windows
My autofilter is not doing what I was hoping it would ...
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?
VBA Code:
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?