Little problem with the REPLACE method.

[jase]

I 'm sure someone has had this problem before.
(It's very similar to a problem I had with the Find method that was
solved in an earlier thread)

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 (zero): and
are
therefore returning "0-Jan-00" in the above format. Therefore why
does the below code NOT replace the values in these cells! (the below
doesn 't seem to throw an error either which is sort of strange)
I got the below code from the macro recorder and then just changed
xlPart to xlWhole.

Columns("C:C").Select
Selection.Replace What:="0-Jan-00", Replacement:="n/a", _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
MatchCase:=True

any help greatly appreciated
Jason

[Jim May]

Try replacing What:="0-Jan-00" with
What:= 0
Since that is the actual content of the cell.
HTH

"jase" <[email protected]> wrote in message
news:[email protected]...
>I 'm sure someone has had this problem before.
> (It's very similar to a problem I had with the Find method that was
> solved in an earlier thread)
>
> 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 (zero): and
> are
> therefore returning "0-Jan-00" in the above format. Therefore why
> does the below code NOT replace the values in these cells! (the below
> doesn 't seem to throw an error either which is sort of strange)
> I got the below code from the macro recorder and then just changed
> xlPart to xlWhole.
>
> Columns("C:C").Select
> Selection.Replace What:="0-Jan-00", Replacement:="n/a", _
> LookAt:=xlWhole, SearchOrder:=xlByRows, _
> MatchCase:=True
>
> any help greatly appreciated
> Jason
>

[jase]

Thanks
I'll give that a go

J