|
Sub zz()
Dim ce As Range, d, sh As Worksheet
Set d = CreateObject("Scripting.Dictionary")
Application.ScreenUpdating = False
For Each ce In Range("A3:a" & [a65536].End(3).Row).SpecialCells(xlCellTypeVisible)
d(ce.Value & ce.Offset(0, 1).Value) = ""
Next
For Each sh In Sheets
If sh.Name <> "分类表" Then
With sh
.UsedRange.Rows.Hidden = False
For i = .[a65536].End(3).Row - 1 To 3 Step -1
If Not d.exists(.Cells(i, 1).Value & .Cells(i, 2).Value) Then .Rows(i).Hidden = True
Next
End With
End If
Next
Application.ScreenUpdating = True
End Sub
|
|