View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jase[_2_] jase[_2_] is offline
external usenet poster
 
Posts: 29
Default 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