|
发表于 2012-5-4 11:31
|
显示全部楼层
本楼为最佳答案
- Sub df()
- Dim Arr, i&, Ar() As Long, j As Byte, K&, A(1 To 2) As Long
- Arr = [a1].CurrentRegion.Value
- ReDim Ar(1 To 60000, 1 To UBound(Arr, 2))
- A(1) = Application.InputBox("ÇëÊäÈëAÁÐҪɸѡµÄÖµ", "È·ÈÏ", [a1], , , , , 1)
- A(2) = Application.InputBox("ÇëÊäÈëBÁÐҪɸѡµÄÖµ", "È·ÈÏ", [b1], , , , , 1)
- If A(1) > 0 And A(2) > 0 Then
- For i = 1 To UBound(Arr)
- If Arr(i, 1) = A(1) And Arr(i, 2) = A(2) Then
- K = K + 1
- For j = 1 To UBound(Arr, 2)
- Ar(K, j) = Arr(i, j)
- Next
- End If
- Next i
- End If
- With Sheet2
- .Cells.ClearContents
- .[a1].Resize(K, UBound(Ar, 2)) = Ar
- End With
- End Sub
复制代码 |
|