Easy Question

[KOK]

Hello All,

I have a following code in which I want to use value of Lookat and MatchCase based upon the value in cell B8 and B9 resprctively.

For ex. If cell B8 has value "No" then Lookat will search xlpart and if "Yes" then Lookat will search xlwhole.

and for match case if the cell value is "Yes" then it will search matchcase as TRUE and if "No" then it will search as FALSE.

wSheet.Cells.Replace What:=Search, Replacement:=Replacement, Lookat:=xlWhole, MatchCase:=True.

Thanks in Advance!!

 

[RoryA]

For example:

wSheet.Cells.Replace What:=Search, Replacement:=Replacement, Lookat:=iif(lcase$(Range("B8").value)="no",xlPart,xlWhole), MatchCase:=iif(lcase$(Range("B9").value)="no",False,True)

 

[KOK]

For example:

wSheet.Cells.Replace What:=Search, Replacement:=Replacement, Lookat:=iif(lcase$(Range("B8").value)="no",xlPart,xlWhole), MatchCase:=iif(lcase$(Range("B9").value)="no",False,True)

Thanks RoryA for your great Help!!..