|
Sub test()
Dim A, B, i, j, s
A = Application.Intersect(Range("a1").CurrentRegion, Range("a:h"))
ReDim B(1 To UBound(A) * 4, 1 To 2)
For i = 2 To UBound(A)
For j = 1 To UBound(A, 2) Step 2
If Len(A(i, j)) Then
s = s + 1
B(s, 1) = A(i, j)
B(s, 2) = A(i, j + 1)
End If
Next j
Next i
Range("n:o").ClearContents
Range("n2").Resize(s, 2) = B
End Sub
1.rar
(1.12 MB, 下载次数: 5)
|
|