For Each Zelle_in_der_Schleife.... verkürzen
11.07.2007 02:46:00
Karsten
...kann mir jemand diese Aktion kürzer machen?
For Each Zelle_in_der_Schleife In Range("M5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, 0).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("M5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -1).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -2).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -3).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -4).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -5).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -6).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -7).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -8).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -9).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -10).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Montag" Then
With Zelle_in_der_Schleife.Offset(0, -11).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, 0).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -1).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -2).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -3).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -4).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -5).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -6).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -7).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -8).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -9).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -10).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Dienstag" Then
With Zelle_in_der_Schleife.Offset(0, -11).Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, 0).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -1).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -2).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -3).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -4).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -5).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -6).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -7).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -8).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -9).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -10).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Mittwoch" Then
With Zelle_in_der_Schleife.Offset(0, -11).Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, 0).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -1).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -2).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -3).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -4).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -5).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -6).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -7).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -8).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -9).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -10).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Donnerstag" Then
With Zelle_in_der_Schleife.Offset(0, -11).Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, 0).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -1).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -2).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -3).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -4).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -5).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -6).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -7).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -8).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -9).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -10).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
For Each Zelle_in_der_Schleife In Range("m5:c31")
If Zelle_in_der_Schleife.Value = "Freitag" Then
With Zelle_in_der_Schleife.Offset(0, -11).Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
End If
Next
Mal wieder vielen Dank im voraus!
Gruß
Karsten