|
- Sub aaa()
- Dim j&, wc, name, rng As Range
- wc = ThisWorkbook.Sheets.Count
- With Sheets(wc)
- Set rng = .Range("a4:j" & .[b65536].End(3).row)
- If .Cells(2, 4) <> "" Then rng.AutoFilter Field:=6, Criteria1:=.Cells(2, 4).Value Else rng.AutoFilter Field:=6 '日期
- If .Cells(2, 5) <> "" Then rng.AutoFilter Field:=9, Criteria1:=.Cells(2, 5).Value Else rng.AutoFilter Field:=9 '是否借阅
- For j = 2 To 3
- If .Cells(2, j) <> "" Then rng.AutoFilter Field:=j + 1, Criteria1:="*" & .Cells(2, j) & "*" Else rng.AutoFilter Field:=j + 1
- Next
- End With
- End Sub
复制代码 |
|