Hi,
Can someone tell me how loop this code downwards over the A and B columns? Right now, it works on sheet 1 only to replace all instances of the text in Sheet 3, A1, with the text in Sheet 3, B1, but I want it to do the same thing again, replacing A2 with B2, etc, and then stop when it hits a blank cell in the A column.
Sub ExecuteSearches()
'
' ExecuteSearches Macro
'
Sheets("Sheet1").Select
Cells.Replace What:=Sheets("Sheet3").Range("A1"), Replacement:=Sheets("Sheet3").Range("B1"), LookAt _
:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Thanks for reading
Bookmarks