Find and replace VBA code.
Worksheets("Sheet Name").Columns("Column").Replace _
What:=What to Replace, Replacement:=Replace with, _
SearchOrder:=xlByColumns, MatchCase:=True
Find and replace VBA code.
Worksheets("Sheet Name").Columns("Column").Replace _
What:=What to Replace, Replacement:=Replace with, _
SearchOrder:=xlByColumns, MatchCase:=True