This really worked.

Thanks.

Regards,

Gijs Breedveld

"Tom Ogilvy" wrote:

Sub ReplaceData()
Range("E2:E250").Replace _
What:="MAR", _
Replacement:="MRT", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False
End Sub

--
Regards,
Tom Ogilvy


"Gijs Breedveld" wrote in message
...
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