|
- Dim rng As Range, t, Sht As Worksheet, Arr, col%
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Address <> "$E$3" Then Exit Sub
- Dim i&, d
- Set d = CreateObject("Scripting.Dictionary")
- For Each Sht In Sheets
- If Sht.Name <> "筛选条件" Then
- Sht.Activate
- Arr = Sht.UsedRange
- Call bt(Arr)
- For i = 4 To UBound(Arr)
- d(Arr(i, col)) = d(Arr(i, col)) & i & ","
- Next
- Sht.Rows(4).Resize(UBound(Arr) - 3).EntireRow.Hidden = True
- If d.exists(Target.Value) Then
- t = d(Target.Value)
- Call yy(t)
- End If
- If d.exists("") Then
- t = d("")
- Call yy(t)
- End If
- If Not rng Is Nothing Then rng.EntireRow.Hidden = False
- Set rng = Nothing
- d.RemoveAll
- End If
- Next
- End Sub
复制代码 |
|