in einem Workbook muss ich immer die konstante Zellen (Werte ) loeschen.
Der Code ist sehr lang.
Vielleich kann ich den Code mit eine Schleife verkuerzen.
Weis aber nicht wie ich den Code unschreiben muss.
Gruss marc :o)
Bitte nicht erschrecken !
Sub SheetsValue_delete02()
With Worksheets("M90.1")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
End With
With Worksheets("M90.1")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
End With
With Worksheets("M90.2")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
End With
With Worksheets("M90.2")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
End With
With Worksheets("M90.3")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
End With
With Worksheets("M90.3")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
End With
With Worksheets("M93.1")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
End With
With Worksheets("M93.1")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
End With
With Worksheets("M93.2")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
End With
With Worksheets("M93.2")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
End With
With Worksheets("M93.3")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
End With
With Worksheets("M93.3")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
End With
With Worksheets("M93.4")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
End With
With Worksheets("M93.4")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
End With
With Worksheets("TL90")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
.Range("X7:X11").Value = ""
.Range("X16:X20").Value = ""
End With
With Worksheets("TL90")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
.Range("X28:X32").Value = ""
.Range("X37:X41").Value = ""
End With
With Worksheets("TL93")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
.Range("X7:X11").Value = ""
.Range("X16:X20").Value = ""
End With
With Worksheets("TL93")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
.Range("X28:X32").Value = ""
.Range("X37:X41").Value = ""
End With
With Worksheets("AL")
.Range("S7:V11").Value = ""
.Range("S16:V20").Value = ""
.Range("V12", "V21").Value = ""
.Range("X7:Y11").Value = ""
Range("X16:Y20").Value = ""
End With
With Worksheets("AL")
.Range("S28:V32").Value = ""
.Range("S37:V41").Value = ""
.Range("V33", "V42").Value = ""
.Range("X28:Y32").Value = ""
.Range("X37:Y41").Value = ""
End With
End Sub
<pre/>