Replace information in all sheets of the workbook : Replace « Forms « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Forms
3. Replace

Replace information in all sheets of the workbook

 

Sub ChgInfo()
    Dim Sht As Worksheet
    For Each Sht In Worksheets
        Sht.Cells.Replace What:="old", Replacement:="new", LookAt:=xlPart, MatchCase:=False
    Next
End Sub

 

Related examples in the same category