AW: Datensätze automatisch ausblenden
17.08.2009 08:13:59
fcs
Hallo Thomas,
hier mein Lösungsvorschlag.
Gruß
Franz
Sub Finden()
Application.ScreenUpdating = False
With ActiveSheet
.Cells.EntireRow.Hidden = False
'Hier ggf. Die Eingabezelle und den zu durchsuchenden Bereich anpassen, _
zur Zeit B2:Bxxx
Call QuickSearch(wks:=ActiveSheet, strFinden:=Range("A1"), _
Bereich:=.Range(.Cells(2, 2), .Cells(.Rows.Count, 2).End(xlUp)))
End With
Application.ScreenUpdating = True
End Sub
Sub QuickSearch(wks As Worksheet, strFinden As Variant, Bereich As Range)
Dim rngEinblenden As Range, rngSearch As Range, Zeile As Long
On Error GoTo Fehler
Set rngSearch = Bereich
Do Until IsError(Application.WorksheetFunction.Match(strFinden & "*", rngSearch, 0))
Zeile = Application.WorksheetFunction.Match(strFinden & "*", rngSearch, 0)
If rngEinblenden Is Nothing Then
Set rngEinblenden = rngSearch.Cells(Zeile, 1).EntireRow
Else
Set rngEinblenden = Application.Union(rngEinblenden, _
rngSearch.Cells(Zeile, 1).EntireRow)
End If
If Zeile