Thread: Find Replace
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Find Replace

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