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
| Sub Datum()
Dim z As Integer
Dim s As Integer
z = 5
s = 21
Worksheets("Gesamtübersicht").Activate
If Cells(z, 2).Value = True And Cells(z + 1, 2).Value = False And Cells(z + 2, 2).Value = FalseAnd And Cells(z + 3, 2).Value = False And Cells(z + 4, 2).Value = False And Cells(z + 5, 2).Value = False And Cells(z + 6, 2).Value = False And Cells(z + 7, 2).Value = False And Cells(z + 8, 2).Value = False And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 1
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = False And Cells(z + 3, 2).Value = False And Cells(z + 4, 2).Value = False And Cells(z + 5, 2).Value = False And Cells(z + 6, 2).Value = False And Cells(z + 7, 2).Value = False And Cells(z + 8, 2).Value = False And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 2
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = False And Cells(z + 4, 2).Value = False And Cells(z + 5, 2).Value = False And Cells(z + 6, 2).Value = False And Cells(z + 7, 2).Value = False And Cells(z + 8, 2).Value = False And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 3
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = True And Cells(z + 4, 2).Value = False And Cells(z + 5, 2).Value = False And Cells(z + 6, 2).Value = False And Cells(z + 7, 2).Value = False And Cells(z + 8, 2).Value = False And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 4
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = True And Cells(z + 4, 2).Value = True And Cells(z + 5, 2).Value = False And Cells(z + 6, 2).Value = False And Cells(z + 7, 2).Value = False And Cells(z + 8, 2).Value = False And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 5
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = True And Cells(z + 4, 2).Value = True And Cells(z + 5, 2).Value = True And Cells(z + 6, 2).Value = False And Cells(z + 7, 2).Value = False And Cells(z + 8, 2).Value = False And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 6
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = True And Cells(z + 4, 2).Value = True And Cells(z + 5, 2).Value = True And Cells(z + 6, 2).Value = True And Cells(z + 7, 2).Value = False And Cells(z + 8, 2).Value = False And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 7
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = True And Cells(z + 4, 2).Value = True And Cells(z + 5, 2).Value = True And Cells(z + 6, 2).Value = True And Cells(z + 7, 2).Value = True And Cells(z + 8, 2).Value = False And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 8
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = True And Cells(z + 4, 2).Value = True And Cells(z + 5, 2).Value = True And Cells(z + 6, 2).Value = True And Cells(z + 7, 2).Value = True And Cells(z + 8, 2).Value = True And Cells(z + 9, 2).Value = False And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 9
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = True And Cells(z + 4, 2).Value = True And Cells(z + 5, 2).Value = True And Cells(z + 6, 2).Value = True And Cells(z + 7, 2).Value = True And Cells(z + 8, 2).Value = True And Cells(z + 9, 2).Value = True And Cells(z + 10, 2).Value = False Then
Cells(3, s) = (Cells(z, 1).Value) + 10
ElseIf Cells(z, 2).Value = True And Cells(z + 1, 2).Value = True And Cells(z + 2, 2).Value = True And Cells(z + 3, 2).Value = True And Cells(z + 4, 2).Value = True And Cells(z + 5, 2).Value = True And Cells(z + 6, 2).Value = True And Cells(z + 7, 2).Value = True And Cells(z + 8, 2).Value = True And Cells(z + 9, 2).Value = True And Cells(z + 10, 2).Value = True Then
Cells(3, s) = (Cells(z, 1).Value) + 11
End Sub |
Partager