Thread: Find and replace If Then ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Office_Novice Office_Novice is offline
external usenet poster
  
Posts: 245
Default Find and replace If Then ?
Here is what I haveCells.Replace What:="Insurance Company Insurance Policy #
RBH26374", Replacement:= _
"Insurance Policy - Insurance Company", LookAt:=xlPart,
SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

What i need is ...

If the words insurance company appears i need to replace them with
"Insurance Policy - Insurance Company" is this possible?
Reply With QuoteReply With Quote