Sub Macro1()
Dim arr, rng As Range, i&
arr = Range("a2:b" & Range("a65536").End(xlUp).Row)
Set rng = Range("c2:c" & Range("c65536").End(xlUp).Row)
For i = 1 To UBound(arr)
rng.Replace arr(i, 1), arr(i, 2)
Next
End Sub
Sub Macro1()
Dim arr, rng As Range, i&
arr = Range("a2:b" & Range("a65536").End(xlUp).Row)
Set rng = Range("c2:c" & Range("c65536").End(xlUp).Row)
For i = 1 To UBound(arr)
rng.Replace arr(i, 1), arr(i, 2)
Next
End Sub