Sub Ersetzen() Columns("A:A").Replace What:="Anton", Replacement:="Berta", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Columns("B:B").Replace What:="Cäsar", Replacement:="Dora", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub
Option Explicit Sub test() Dim intI As Integer For intI = 1 To 100 'Zeile anpassen If Cells(intI, 1).Value = "Anton" Then Cells(intI, 1).Value = "Berta" If Cells(intI, 2).Value = "Cäsar" Then Cells(intI, 2).Value = "Dora" Next End Sub
58.4k Fragen
249k Antworten
7k Nutzer