|
Sub 测试()
Dim arr
Set d = CreateObject("scripting.dictionary")
arr = Sheets("问题").Range("b11:i27")
ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2) - 1)
ReDim crr(1 To UBound(arr), 1 To UBound(arr, 2) - 1)
ar = Application.Transpose(Application.Transpose(Range("z8:ab8")))
For i = 1 To UBound(arr)
d.RemoveAll
For j = 2 To UBound(arr, 2)
d(arr(i, j)) = ""
Next j
For k = 1 To UBound(ar)
If Not d.exists(ar(k)) Then
GoTo 100
End If
Next k
n = n + 1
For j = 1 To UBound(arr, 2) - 1
brr(n, j) = arr(i, j)
crr(n, j) = arr(i + 1, j)
Next j
100: Next i
Sheets("问题").[q11].Resize(UBound(brr), UBound(brr, 2)) = brr
Sheets("问题").[y11].Resize(UBound(crr), UBound(crr, 2)) = crr
End Sub
|
|