This also works great.

Thanks,

Regards,

Gijs Breedveld


"Gary''s Student" wrote:

Sub Macro1()
Range("E2:E250").Select
Selection.Replace What:="MAR", Replacement:="MRT"
End Sub

--
Gary's Student


"Gijs Breedveld" wrote:

Hi,

I am trying to write a macro that replaces the word MAR into MRT for column
E and in the range 2:250

Doe sanyone has that code for me?

It would help me very much.

Best regards, Gijs