Problem with the FIND method looking for dates.
Help!
I'm sure someone has had this problem before.
Column C is a column of dates, and is formatted as "14-Mar-98".
Some of the cells in column C contain, in integer form, 0 : and are
therefore returning "00/01/1900" in the above format. Therefore why
does the below throw an error! The below code was the result of using
the macro recorder.
Columns("C:C").Select
Selection.Find(What:="00/01/1900", After:=ActiveCell, _
LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False).Activate
Any help greatly appreciated
Jason
|