Code optimieren
20.12.2017 19:34:58
Marco
ich wollt mal in die Runde fragen ob man den Code schlanker machen kann?
Sub StartLöschen()
Dim z As Integer
For z = 13 To 51
Sheets("1").Range(Cells(z, 10), Cells(z, 11)) = ""
Sheets("1").Range(Cells(z, 14), Cells(z, 15)) = ""
Sheets("1").Range(Cells(z, 18), Cells(z, 19)) = ""
Sheets("1").Range(Cells(z, 22), Cells(z, 23)) = ""
Sheets("1").Range(Cells(z, 10), Cells(z, 12)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 14), Cells(z, 16)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 18), Cells(z, 20)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 22), Cells(z, 24)).Interior.Pattern = xlNone
Next z
For z = 60 To 134
Sheets("1").Range(Cells(z, 10), Cells(z, 11)) = ""
Sheets("1").Range(Cells(z, 14), Cells(z, 15)) = ""
Sheets("1").Range(Cells(z, 18), Cells(z, 19)) = ""
Sheets("1").Range(Cells(z, 22), Cells(z, 23)) = ""
Sheets("1").Range(Cells(z, 10), Cells(z, 12)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 14), Cells(z, 16)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 18), Cells(z, 20)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 22), Cells(z, 24)).Interior.Pattern = xlNone
Next z
For z = 143 To 190
Sheets("1").Range(Cells(z, 10), Cells(z, 11)) = ""
Sheets("1").Range(Cells(z, 14), Cells(z, 15)) = ""
Sheets("1").Range(Cells(z, 18), Cells(z, 19)) = ""
Sheets("1").Range(Cells(z, 22), Cells(z, 23)) = ""
Sheets("1").Range(Cells(z, 10), Cells(z, 12)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 14), Cells(z, 16)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 18), Cells(z, 20)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 22), Cells(z, 24)).Interior.Pattern = xlNone
Next z
End Sub
Ich habe versucht den Code damit abzuspecken, aber das hat leider nicht funktioniert.
Geht so was nicht bei For Next Schleifen oder welche Regeln gibt es zu beachten?
StartLöschen()
Dim z As Integer
For z = 13 To 51 and 60 To 134 and 143 To 190
Sheets("1").Range(Cells(z, 10), Cells(z, 11)) = ""
Sheets("1").Range(Cells(z, 14), Cells(z, 15)) = ""
Sheets("1").Range(Cells(z, 18), Cells(z, 19)) = ""
Sheets("1").Range(Cells(z, 22), Cells(z, 23)) = ""
Sheets("1").Range(Cells(z, 10), Cells(z, 12)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 14), Cells(z, 16)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 18), Cells(z, 20)).Interior.Pattern = xlNone
Sheets("1").Range(Cells(z, 22), Cells(z, 24)).Interior.Pattern = xlNone
Next z
End Sub