dim Cel as Range for each Cel in YourRange 'Edit YourRange to reflect reality If Cel = "English Section details" And Cel.Offset(1) = "Terms" Then _ Cel.Offset(1) = "English Terms" Next
dim Cel as Range for each Cel in YourRange 'Edit YourRange to reflect reality If Cel = "English Section details" And Cel.Offset(1) = "Terms" Then _ Cel.Offset(1) = "English Terms" Next
Please take the time to read the Forum FAQ
Reply With Quote
