Hey guys,

I have this code:

'Replace
Cells.Replace What:="Order", Replacement:="Lead", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

If (Cells(10, 7) = "Y") Then

given the situation above, If its yes then it will search the entire workbook let say around 5 sheets to replace all ORDER from LEAD.

May I please know how to properly code it.

Thanks