I currently have the following code that I have been using to find and replace cell contents...

Cells.Replace What:="MC9090-GF0SJEFA69R", Replacement:= _
        "Symbol-MC9090 Core Store Scan Gun", LookAt:=xlPart, SearchOrder:=xlByRows, _
        MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
However, I want to search cells within a particular column for a specified string of text and then replace the ENTIRE contents with something else. How do can I do that with either this code or with a different code?


THANKS!!!!!