On May 11th, 2008, 06:38 PM, MrExcelMVP "Fazza" provided an excellent code in response to a request by "gravy679" titled "Match and replace cell from another sheet": http://www.mrexcel.com/forum/showthread.php?t=318911
Sub test()
Application.ScreenUpdating = False
Dim cel As Range
For...