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

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

"J Chokshi" wrote:

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