Replace text in specific column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Sub ReplaceData()
Range("E2:E250").Replace _
What:="MAR", _
Replacement:="MRT", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False
End Sub
 
Gijs

Try this

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Sub Macro1()
Range("E2:E250").Select
Selection.Replace What:="MAR", Replacement:="MRT"
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
column loop 3
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Replacing spaces with underscore for specific expressions 8
Transfer array element offset value to a matched value 3
Input box replace text in textbox 1
Run macro on all files in a specific folder 3

Back
Top