和本题无关!- Sub tt()
- Dim arr, arr1(1 To 1000, 1 To 6), x, p, k
- Range("A3:F1000").Clear
- x = Sheets(4).Range("a65536").End(3).Row
- arr = Sheets(4).Range("a2:f" & x)
- For p = 1 To UBound(arr)
- If arr(p, 1) = Range("B1").Text Then
- k = k + 1
- arr1(k, 1) = arr(p, 1)
- arr1(k, 2) = arr(p, 2)
- arr1(k, 3) = arr(p, 3)
- arr1(k, 4) = arr(p, 4)
- arr1(k, 5) = arr(p, 5)
- arr1(k, 6) = arr(p, 6)
- End If
- Next
- Range("A3").Resize(k, 6) = arr1
- End Sub
复制代码 |