1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Call Macro97
Dim i As Long
Dim a As Long
Dim b As Long
Dim c As Long
Dim d As Long
Dim e As Long
derligW = Range("W65000").End(xlUp).Row
derligBU = Range("BU65000").End(xlUp).Row
For i = 1 To derligW
For a = 1 To derligBU
For b = a To derligBU
For c = b To derligBU
For d = c To derligBU
For e = d To derligBU
If (Cells(i, 1) = Cells(a, 73) And Cells(i, 2) = Cells(b, 73) And Cells(i, 3) = Cells(c, 73)) _
Or (Cells(i, 1) = Cells(a, 73) And Cells(i, 2) = Cells(b, 73) And Cells(i, 4) = Cells(d, 73)) _
Or (Cells(i, 1) = Cells(a, 73) And Cells(i, 2) = Cells(b, 73) And Cells(i, 5) = Cells(e, 73)) _
Or (Cells(i, 1) = Cells(a, 73) And Cells(i, 3) = Cells(c, 73) And Cells(i, 4) = Cells(d, 73)) _
Or (Cells(i, 1) = Cells(a, 73) And Cells(i, 3) = Cells(c, 73) And Cells(i, 5) = Cells(e, 73)) _
Or (Cells(i, 1) = Cells(a, 73) And Cells(i, 4) = Cells(d, 73) And Cells(i, 5) = Cells(e, 73)) _
Or (Cells(i, 2) = Cells(b, 73) And Cells(i, 3) = Cells(c, 73) And Cells(i, 4) = Cells(d, 73)) _
Or (Cells(i, 2) = Cells(b, 73) And Cells(i, 3) = Cells(c, 73) And Cells(i, 5) = Cells(e, 73)) _
Or (Cells(i, 2) = Cells(b, 73) And Cells(i, 4) = Cells(d, 73) And Cells(i, 5) = Cells(e, 73)) _
Or (Cells(i, 3) = Cells(c, 73) And Cells(i, 4) = Cells(d, 73) And Cells(i, 5) = Cells(e, 73)) Then
Range(Cells(i, 23), Cells(i, 27)).Copy
Range("BX65000").End(xlUp).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste
GoTo un
End If
Next e
Next d
Next c
Next b
Next a
un:
Next i
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub |
Partager