View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Replace text in specific column

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