Ein langsamer Coder
24.07.2004 18:06:42
marc
der unten stehender Coder braucht 4 Minuten lang fuer die Abarbeitung.
Wie kann ich den Coder schneller machen ?
marc.
Option Explicit
Sub SheetsValue_delete()
Const RN1 = "S7:V11"
Const RN2 = "S16:V20"
Const RN3 = "S28:V32"
Const RN4 = "S37:V41"
Const RN5 = "X7:X11"
Const RN6 = "X16:X20"
Const RN7 = "X28:X32"
Const RN8 = "X37:X41"
Const RN9 = "V12"
Const RN10 = "V21"
Const RN11 = "XV33"
Const RN12 = "V42"
Dim fd() As Variant, I%, ws As Worksheet
On Error Resume Next
fd = Array("90.1", "90.2", "90.3", "93.1", "93.2", "93.3", "93.4", "90A", "93B", "BCC", "ECC")
For I = 0 To UBound(fd)
Set ws = Worksheets(fd(I))
ws.Range(RN1).ClearContents
ws.Range(RN2).ClearContents
ws.Range(RN3).ClearContents
ws.Range(RN4).ClearContents
ws.Range(RN5).ClearContents
ws.Range(RN6).ClearContents
ws.Range(RN7).ClearContents
ws.Range(RN8).ClearContents
ws.Range(RN9).ClearContents
ws.Range(RN10).ClearContents
ws.Range(RN11).ClearContents
ws.Range(RN12).ClearContents
Next I
Set ws = Nothing
End Sub