Find Replace

J

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
 
M

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
 
Top