|
发表于 2011-6-17 16:04
|
显示全部楼层
本楼为最佳答案
本帖最后由 蓝桥玄霜 于 2011-6-17 16:08 编辑
- Sub yy()
- Dim i&, Myr&, Myc%, Arr, rq1, m&
- Dim rq, Brr, j&, ii&, r1, r%, Arr1()
- Sheet1.Activate
- rq = [h2].Value
- Myc = [iv3].End(xlToLeft).Column
- Brr = Range("h3", Cells(3, Myc))
- Myr = Sheet2.[d65536].End(xlUp).Row
- Arr = Sheet2.Range("d6:i" & Myr)
- Set r1 = Sheet2.[d:d].Find(rq)
- If Not r1 Is Nothing Then
- For i = 1 To UBound(Brr, 2)
- m = 0
- For j = r1.Row - 6 To 6 Step -1
- If Arr(j, 2) = Brr(1, i) Then
- m = m + 1
- If m = 1 Then rq1 = Arr(j, 1)
- If rq1 - Arr(j, 1) > 4 And rq1 <> "" Then Exit For
- r = r + 1
- ReDim Preserve Arr1(1 To 6, 1 To r)
- For ii = 1 To 6
- Arr1(ii, r) = Arr(j, ii)
- Next
- End If
- Next
- Next
- End If
- [f8].Resize(6, 200).ClearContents
- [f8].Resize(6, r) = Arr1
- End Sub
复制代码 |
|