I have set MyDate as Date
MyDate = 12/17/17 07:52:52 PM
I want to search this in following data in column A. Search result is present at cell A5.
17 Dec 17 19:51:33 Extra Load
17 Dec 17 19:52:09 Minimum age of 18 verified
17 Dec 17 19:52:16 Extra Load
17 Dec 17 19:52:47 Extra Load
17 Dec 17 19:52:52 Minimum age of 18 verified
17 Dec 17 19:55:32 Villaged
17 Dec 17 20:00:10 Minimum age of 18 verified
17 Dec 17 20:00:24 Old Relative
17 Dec 17 20:02:32 Villaged
Can a vba code search this 12 HR format date from 24 Hr format text data and return the row number of that cell from range.
Bookmarks