Für die Hilfe im voraus vielen Dank
Option Explicit
Sub Test()
' erstellt von Hajo.Ziplies@web.de 12.04.03
Dim Found As Range
Dim LoLetzte As Long
Dim sSearch As String
sSearch = InputBox("Suchbegriff:", , "test")
If sSearch = "" Then Exit Sub
LoLetzte = IIf(IsEmpty(Range("C65536")), Range("C65536").End(xlUp).Row, 65536)
Set Found = Range("C1:C" & LoLetzte).Find(sSearch, Range("C" & LoLetzte), , xlPart, , xlNext)
' kompletter Vergleich und Inhalt
' Set Found = .Range(.Cells(2, 10), .Cells(5753, 10)).Find(ActiveSheet.Cells(I, 54), _
' .Cells(5753, 10), xlValues , xlWhole, , xlNext)
If Found Is Nothing Then Exit Sub 'falls nicht gefunden wird sub verlassen
MsgBox Found.Row
End Sub
Sub Test()
' erstellt von Hajo.Ziplies@web.de 12.04.03
Dim Found As Range
Dim sSearch As String
sSearch = InputBox("Suchbegriff:", , "test")
If sSearch = "" Then Exit Sub
Set Found = Range("C1:Z1").Find(sSearch, Range("Z1"), , xlPart, , xlNext)
' kompletter Vergleich und Inhalt
' Set Found = .Range(.Cells(2, 10), .Cells(5753, 10)).Find(ActiveSheet.Cells(I, 54), _
' .Cells(5753, 10), xlValues , xlWhole, , xlNext)
If Found Is Nothing Then
MsgBox "nicht gefunden"
Else
Found.Activate
End If
End Sub