Sub ´Ü¾îġȯ()
Dim ãÀ»´Ü¾î As Range
Dim ´ëü´Ü¾î As Range
Dim i AsLongDim ¸¶Áö¸·Çà AsLong
¸¶Áö¸·Çà = Cells(Rows.Count, 1).End(xlUp).Row
Set ãÀ»´Ü¾î = Range("A1:A" & ¸¶Áö¸·Çà)
Set ´ëü´Ü¾î = Range("B1:B" & ¸¶Áö¸·Çà)
For i = 1To ¸¶Áö¸·Çà
Cells(i, 2).Value = Replace(Cells(i, 1).Value, ãÀ»´Ü¾î(i).Value, ´ëü´Ü¾î(i).Value)
Next i
EndSub