|
Sub 查询()
Dim ar As Variant
Dim br()
ar = Sheets("数据源").[a1].CurrentRegion
ReDim br(1 To UBound(ar), 1 To 7)
With Sheets("查询窗口")
rr = Array(.Range("b2").Address, .Range("e2").Address, .Range("h2").Address)
If Trim(.Range("b2")) <> "" And Trim(.Range("e2")) = "" And Trim(.Range("h2")) = "" Then
lh = 12
zd = .Range("b2")
ElseIf Trim(.Range("b2")) = "" And Trim(.Range("e2")) <> "" And Trim(.Range("h2")) = "" Then
lh = 15
zd = .Range("e2")
ElseIf Trim(.Range("b2")) = "" And Trim(.Range("e2")) = "" And Trim(.Range("h2")) <> "" Then
lh = 2
zd = .Range("h2")
End If
If lh = "" Then MsgBox "查询条件输入有误!": Exit Sub
For i = 5 To UBound(ar)
If InStr(ar(i, lh), zd) > 0 Then
n = n + 1
br(n, 1) = n
br(n, 2) = ar(i, 2)
br(n, 3) = ar(i, 3)
br(n, 4) = ar(i, 12)
br(n, 5) = ar(i, 13)
br(n, 6) = ar(i, 15)
br(n, 7) = ar(i, 16)
End If
Next i
If n = "" Then MsgBox "没有符合条件的数据!": Exit Sub
r = .Cells(Rows.Count, 1).End(xlUp).Row + 1
.Range("a8:g" & r) = Empty
.[a8].Resize(n, UBound(br, 2)) = br
End With
MsgBox "查询成功!", 64, "提醒"
End Sub
|
评分
-
1
查看全部评分
-
|