View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Replace text in specific column

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