Help w/ VBA
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
|