I have a range of cells that I have to replace the date 00-00-00 with the date in A4 (06-01-10) for example. The find and replace works manually. My macro doesn't:
Range("A5:C5").Select
Selection.Replace What:="00-00-00", Replacement:=Range("A4"), LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=True, _
ReplaceFormat:=False
Original data:
=IF(ISERROR(VLOOKUP($A57,'V:\Jun\[cases-00-00-00.xlsx]Sheet1'!$A$4:$B$40,1,FALSE)),"",VLOOKUP($A57,'V:\Jun\[cases-00-00-00.xlsx]Sheet1'!$A$4:$B$40,1,FALSE))

What happens:
=IF(ISERROR(VLOOKUP($A57,'V:\Jun\[cases-6/1/[2010.xlsx]Sheet1]2010.xlsx]Sheet1'!$A$4:$B$40,1,FALSE)),"",VLOOKUP($A57,'V:\Jun\[cases-6/1/[2010.xlsx]Sheet1]2010.xlsx]Sheet1'!$A$4:$B$40,1,FALSE))

Is there any way to force my xx-xx-xx format in a find and replace vba statement?

Thanks,
Ron