|
'设数据是从A1单元格开始,无标题
Sub test()
Dim arr, brr, crr, drr
Dim i, j, k, m, n, npoint, nMax, nMaxCol, col
Dim p
nMax = Cells(Rows.Count, 1).End(xlUp).Row
nMaxCol = Cells(1, Columns.Count).End(xlToLeft).Column
col = (nMaxCol + 1) / 3 - 1
ReDim drr(1 To 3 * col - 3)
arr = Range(Cells(1, 1), Cells(nMax, col))
brr = Range(Cells(1, col + 2), Cells(nMax, 2 * col + 2))
crr = Range(Cells(1, 2 * col + 3), Cells(nMax, 3 * col + 3))
npoint = 1
For i = LBound(arr) To UBound(arr)
For j = LBound(brr) To UBound(brr)
For k = LBound(crr) To UBound(crr)
p = 0
For m = 1 To col - 1
drr(m) = arr(i, 1 + m)
drr(col - 1 + m) = brr(j, 1 + m)
drr(2 * col - 2 + m) = crr(k, 1 + m)
Next m
For m = 1 To 3 * col - 4
For n = m + 1 To 3 * col - 3
If drr(m) = drr(n) Then
p = 1
Exit For
End If
Next n
If p Then Exit For
Next m
If p = 0 Then
For m = 1 To col
Cells(nMax + npoint, m) = arr(i, m)
Cells(nMax + npoint, col + 1 + m) = brr(j, m)
Cells(nMax + npoint, 2 * col + 2 + m) = crr(k, m)
Next m
npoint = npoint + 1
End If
Next k
Next j
Next i
End Sub
|
评分
-
1
查看全部评分
-
|