Sub test()
Dim Suche As Variant, Flurbin As Variant
Dim Gefunden As Range, Erste As String, Y As Long
Suche = Array("hello", "my", "another")
Y = 2
With Worksheets("T1").Columns("A")
For Each Flurbin In Suche
Set Gefunden = .Find(Flurbin, LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False)
If Not Gefunden Is Nothing Then
Erste = Gefunden.Address
Do 'für alle Fundstellen
Worksheets("T4").Cells(Y, "B").Value = Gefunden.Offset(0, 1).Value
Y = Y + 1
Set Gefunden = .FindNext(Gefunden)
Loop Until Gefunden.Address = Erste
End If
Next Flurbin
End With
End Sub
Bookmarks