Hi,
Im getting error 13 type mismatch when trying to filter dates not equal to. if i remove "<>" & it works fine. how can i filter all dates not equal to the date and delete.
Thanks
Im getting error 13 type mismatch when trying to filter dates not equal to. if i remove "<>" & it works fine. how can i filter all dates not equal to the date and delete.
VBA Code:
With .UsedRange.Columns("A:G")
.AutoFilter Field:=5, Operator:=xlFilterValues, _
Criteria2:="<>" & Array(2, Format(dt2, "mm/dd/yyyy"))
Offset(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
'.AutoFilter
End With
Thanks