Forms VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Forms
  4. Replacing with the Replace Method
Sub replace()
    ActiveSheet.Columns("B").Replace What:="Sales", _
        Replacement:="Sales & Marketing", SearchOrder:=xlByColumns, _
        MatchCase:=True
End Sub