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!!!!!
Bookmarks