Hey guys,
There must be a way to do this. I have a table and each row has a time column in the format of HH:MM:SS AM/PM. I want to be able to remove (delete) lines that contain a time that's later (and if possible, earlier) than a selected time/timeframe. Here's what I've tried:
Sheets("MC Log Parser").Select
With ActiveSheet.UsedRange
.AutoFilter Field:=3, Criteria1:="*07:##:## PM*"
.Offset(1).SpecialCells(xlVisible).EntireRow.Delete
.AutoFilter
End With
My aim is to filter all but cells that contain anything within 7PM and then delete those visible cells. I think my issue is with the syntax of specifying a range of time. Can anybody help out?
Thanks
MT
Bookmarks