Mega Code Archive

 

Categories / VisualBasic Script / Forms

 

Replacing with the Replace Method

Sub replace()     ActiveSheet.Columns("B").Replace What:="Sales", _         Replacement:="Sales & Marketing", SearchOrder:=xlByColumns, _         MatchCase:=True End Sub