Find Replace

[J Chokshi]

Hi All;

I am looking for something where I can find and replace from macro script.

Any suggestions help will be appreciated.

Thank you and have excellent day,
Jack

 

[Mike H]

Hi,

At it's simplest you can record your self doing it and get something like
this which you can use again.

Cells.Replace What:="This", Replacement:="That", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

If you want to be more specific about what you want then I'm sure someone
will help.

Mike