Mußt in der Schleife:
For a = 1 To 20
text1 = Sheets("Tabelle1").Cells(a, 2)
text2 = Sheets("Tabelle1").Cells(a, 3)
n = InStr(1, text2, meinsuchtext, 1)
If n > 0 Then
text21 = Left(text2, n - 1)
text22 = Mid(text2, n + Len(meinsuchtext), Len(text2) - n)
Sheets("Tabelle1").Cells(a, 3) = text21 + text1 + text22
Sheets("Tabelle1").Cells(a, 2) = ""
End If
Next a
nochmals eine Schleife setzen, z.B:
For a = 1 To 20
For b = 2 To 21
text1 = Sheets("Tabelle1").Cells(a, b-1)
text2 = Sheets("Tabelle1").Cells(a,
n = InStr(1, text2, meinsuchtext, 1)
If n > 0 Then
text21 = Left(text2, n - 1)
text22 = Mid(text2, n + Len(meinsuchtext), Len(text2) - n)
Sheets("Tabelle1").Cells(a, = text21 + text1 + text22
Sheets("Tabelle1").Cells(a, b-1) = ""
End If
Next b
Next a