I want the VBA to replace multiple values in a column, and only that column. Currently when I run this it is replacing the values in all columns on the worksheet.
Code:
Columns("H").Replace What:="CHOICE-UEXB IC*", Replacement:="CHOICE UEXB", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:= _
False, ReplaceFormat:=False