I need to change a group of values to value A, and another group of values to value B
Below is what I have so far, and the code is not working. what am I doing wrong?
Below is what I have so far, and the code is not working. what am I doing wrong?
VBA Code:
Sub CleanUpOutlier()
With Range("D1", Cells(Rows.Count, "D").End(3))
.Replace "F21222CJ-08"",F21222CJ-11""", "F21222CJ"
.Replace "F12315J-67"", F12314J-67""", "F12315J"
End With
End Sub