AW: Suchen und springen
04.10.2012 13:06:37
Tino
Hallo,
wenn A1:N1 verbunden, dann versuchen wir es mal so.
Sub Find_Belastung()
Dim rngFind As Range
With Tabelle1 'Tabelle anpassen
Set rngFind = .Rows("1:3").Find(What:="Belastung", After:=.Cells(3, .Columns.Count), _
LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)
End With
If Not rngFind Is Nothing Then
With rngFind.Parent
Set rngFind = .Range(rngFind, .Cells(.Rows.Count, rngFind.Column))
End With
Application.Goto rngFind, False
Else
MsgBox "nix gefunden!"
End If
End Sub
Gruß Tino