MACROS plötzlich UNENDLICH LANGSAM !!
18.12.2004 21:33:15
TOM
Weiß einer warum ( es wurde an dem Macro eigentlich nicht verändert.
P.s. Das Macro dient zum einschieben einner Leerzeile in jeder 2. Zeile.
Also... was vorher aus 50 untereinander geschriebenen Zeilen bestand , besteht nun aus 100 Zeilen ( jede 2. Zewile ist eine Leerzeile (xxxx)
Hier das Macro
Private Sub CommandButton3_Click()
ActiveSheet.Unprotect
Application.ScreenUpdating = False
Range("A3:E120").Select
Selection.Copy
Range("A4").Select
ActiveSheet.Paste
Range("A3").Select
ActiveCell.FormulaR1C1 = " "
Range("B3").Select
ActiveCell.FormulaR1C1 = " "
Range("D3:E3").Select
Selection.ClearContents
Range("A5:E121").Select
Selection.Copy
Range("A6").Select
ActiveSheet.Paste
Range("A5").Select
ActiveCell.FormulaR1C1 = " "
Range("B5").Select
ActiveCell.FormulaR1C1 = " "
Range("D5").Select
ActiveCell.FormulaR1C1 = " "
Range("E5").Select
ActiveCell.FormulaR1C1 = " "
Range("E6").Select
Range("A7:E121").Select
Selection.Copy
Range("A8").Select
ActiveSheet.Paste
Range("A7").Select
ActiveCell.FormulaR1C1 = " "
Range("B7").Select
ActiveCell.FormulaR1C1 = " "
Range("D7").Select
ActiveCell.FormulaR1C1 = " "
Range("E7").Select
ActiveCell.FormulaR1C1 = " "
Range("E8").Select
Range("A9:E121").Select
Selection.Copy
Range("A10").Select
ActiveSheet.Paste
Range("A9").Select
ActiveCell.FormulaR1C1 = " "
Range("B9").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D9").Select
ActiveCell.FormulaR1C1 = " "
Range("E9").Select
ActiveCell.FormulaR1C1 = " "
Range("E10").Select
Range("A11:E121").Select
Selection.Copy
Range("A12").Select
ActiveSheet.Paste
Range("A11").Select
ActiveCell.FormulaR1C1 = " "
Range("B11").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D11").Select
ActiveCell.FormulaR1C1 = " "
Range("E11").Select
ActiveCell.FormulaR1C1 = " "
Range("E12").Select
Range("A13:E121").Select
Selection.Copy
Range("A14").Select
ActiveSheet.Paste
Range("A13").Select
ActiveCell.FormulaR1C1 = " "
Range("B13").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D13").Select
ActiveCell.FormulaR1C1 = " "
Range("E13").Select
ActiveCell.FormulaR1C1 = " "
Range("E14").Select
Range("A15:E121").Select
Selection.Copy
Range("A16").Select
ActiveSheet.Paste
Range("A15").Select
ActiveCell.FormulaR1C1 = " "
Range("B15").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D15").Select
ActiveCell.FormulaR1C1 = " "
Range("E15").Select
ActiveCell.FormulaR1C1 = " "
Range("E16").Select
Range("A17:E121").Select
Selection.Copy
Range("A18").Select
ActiveSheet.Paste
Range("A17").Select
ActiveCell.FormulaR1C1 = " "
Range("B17").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D17").Select
ActiveCell.FormulaR1C1 = " "
Range("E17").Select
ActiveCell.FormulaR1C1 = " "
Range("E18").Select
Range("A19:E121").Select
Selection.Copy
Range("A20").Select
ActiveSheet.Paste
Range("A19").Select
ActiveCell.FormulaR1C1 = " "
Range("B19").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D19").Select
ActiveCell.FormulaR1C1 = " "
Range("E19").Select
ActiveCell.FormulaR1C1 = " "
Range("E20").Select
Range("A21:E121").Select
Selection.Copy
Range("A22").Select
ActiveSheet.Paste
Range("A21").Select
ActiveCell.FormulaR1C1 = " "
Range("B21").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D21").Select
ActiveCell.FormulaR1C1 = " "
Range("E21").Select
ActiveCell.FormulaR1C1 = " "
Range("E22").Select
Range("A23:E121").Select
Selection.Copy
Range("A24").Select
ActiveSheet.Paste
Range("A23").Select
ActiveCell.FormulaR1C1 = " "
Range("B23").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D23").Select
ActiveCell.FormulaR1C1 = " "
Range("E23").Select
ActiveCell.FormulaR1C1 = " "
Range("E24").Select
Range("A25:E121").Select
Selection.Copy
Range("A26").Select
ActiveSheet.Paste
Range("A25").Select
ActiveCell.FormulaR1C1 = " "
Range("B25").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D25").Select
ActiveCell.FormulaR1C1 = " "
Range("E25").Select
ActiveCell.FormulaR1C1 = " "
Range("E26").Select
Range("A27:E121").Select
Selection.Copy
Range("A28").Select
ActiveSheet.Paste
Range("A27").Select
ActiveCell.FormulaR1C1 = " "
Range("B27").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D27").Select
ActiveCell.FormulaR1C1 = " "
Range("E27").Select
ActiveCell.FormulaR1C1 = " "
Range("E28").Select
Range("A29:E121").Select
Selection.Copy
Range("A30").Select
ActiveSheet.Paste
Range("A29").Select
ActiveCell.FormulaR1C1 = " "
Range("B29").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D29").Select
ActiveCell.FormulaR1C1 = " "
Range("E29").Select
ActiveCell.FormulaR1C1 = " "
Range("E30").Select
Range("A31:E121").Select
Selection.Copy
Range("A32").Select
ActiveSheet.Paste
Range("A31").Select
ActiveCell.FormulaR1C1 = " "
Range("B31").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D31").Select
ActiveCell.FormulaR1C1 = " "
Range("E31").Select
ActiveCell.FormulaR1C1 = " "
Range("E32").Select
Range("A33:E121").Select
Selection.Copy
Range("A34").Select
ActiveSheet.Paste
Range("A33").Select
ActiveCell.FormulaR1C1 = " "
Range("B33").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D33").Select
ActiveCell.FormulaR1C1 = " "
Range("E33").Select
ActiveCell.FormulaR1C1 = " "
Range("E34").Select
Range("A35:E121").Select
Selection.Copy
Range("A36").Select
ActiveSheet.Paste
Range("A35").Select
ActiveCell.FormulaR1C1 = " "
Range("B35").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D35").Select
ActiveCell.FormulaR1C1 = " "
Range("E35").Select
ActiveCell.FormulaR1C1 = " "
Range("E36").Select
Range("A37:E121").Select
Selection.Copy
Range("A38").Select
ActiveSheet.Paste
Range("A37").Select
ActiveCell.FormulaR1C1 = " "
Range("B37").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D37").Select
ActiveCell.FormulaR1C1 = " "
Range("E37").Select
ActiveCell.FormulaR1C1 = " "
Range("E38").Select
Range("A39:E121").Select
Selection.Copy
Range("A40").Select
ActiveSheet.Paste
Range("A39").Select
ActiveCell.FormulaR1C1 = " "
Range("B39").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D39").Select
ActiveCell.FormulaR1C1 = " "
Range("E39").Select
ActiveCell.FormulaR1C1 = " "
Range("E40").Select
Range("A41:E121").Select
Selection.Copy
Range("A42").Select
ActiveSheet.Paste
Range("A41").Select
ActiveCell.FormulaR1C1 = " "
Range("B41").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D41").Select
ActiveCell.FormulaR1C1 = " "
Range("E41").Select
ActiveCell.FormulaR1C1 = " "
Range("E42").Select
Range("A43:E121").Select
Selection.Copy
Range("A44").Select
ActiveSheet.Paste
Range("A43").Select
ActiveCell.FormulaR1C1 = " "
Range("B43").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D43").Select
ActiveCell.FormulaR1C1 = " "
Range("E43").Select
ActiveCell.FormulaR1C1 = " "
Range("E44").Select
Range("A45:E121").Select
Selection.Copy
Range("A46").Select
ActiveSheet.Paste
Range("A45").Select
ActiveCell.FormulaR1C1 = " "
Range("B45").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D45").Select
ActiveCell.FormulaR1C1 = " "
Range("E45").Select
ActiveCell.FormulaR1C1 = " "
Range("E46").Select
Range("A47:E121").Select
Selection.Copy
Range("A48").Select
ActiveSheet.Paste
Range("A47").Select
ActiveCell.FormulaR1C1 = " "
Range("B47").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D47").Select
ActiveCell.FormulaR1C1 = " "
Range("E47").Select
ActiveCell.FormulaR1C1 = " "
Range("E48").Select
Range("A49:E121").Select
Selection.Copy
Range("A50").Select
ActiveSheet.Paste
Range("A49").Select
ActiveCell.FormulaR1C1 = " "
Range("B49").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D49").Select
ActiveCell.FormulaR1C1 = " "
Range("E49").Select
ActiveCell.FormulaR1C1 = " "
Range("E50").Select
Range("A51:E121").Select
Selection.Copy
Range("A52").Select
ActiveSheet.Paste
Range("A51").Select
ActiveCell.FormulaR1C1 = " "
Range("B51").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D51").Select
ActiveCell.FormulaR1C1 = " "
Range("E51").Select
ActiveCell.FormulaR1C1 = " "
Range("E52").Select
Range("A53:E121").Select
Selection.Copy
Range("A54").Select
ActiveSheet.Paste
Range("A53").Select
ActiveCell.FormulaR1C1 = " "
Range("B53").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D53").Select
ActiveCell.FormulaR1C1 = " "
Range("E53").Select
ActiveCell.FormulaR1C1 = " "
Range("E54").Select
Range("A55:E121").Select
Selection.Copy
Range("A56").Select
ActiveSheet.Paste
Range("A55").Select
ActiveCell.FormulaR1C1 = " "
Range("B55").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D55").Select
ActiveCell.FormulaR1C1 = " "
Range("E55").Select
ActiveCell.FormulaR1C1 = " "
Range("E56").Select
Range("A57:E121").Select
Selection.Copy
Range("A58").Select
ActiveSheet.Paste
Range("A57").Select
ActiveCell.FormulaR1C1 = " "
Range("B57").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D57").Select
ActiveCell.FormulaR1C1 = " "
Range("E57").Select
ActiveCell.FormulaR1C1 = " "
Range("E58").Select
Range("A59:E121").Select
Selection.Copy
Range("A60").Select
ActiveSheet.Paste
Range("A59").Select
ActiveCell.FormulaR1C1 = " "
Range("B59").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D59").Select
ActiveCell.FormulaR1C1 = " "
Range("E59").Select
ActiveCell.FormulaR1C1 = " "
Range("E60").Select
Range("A61:E121").Select
Selection.Copy
Range("A62").Select
ActiveSheet.Paste
Range("A61").Select
ActiveCell.FormulaR1C1 = " "
Range("B61").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D61").Select
ActiveCell.FormulaR1C1 = " "
Range("E61").Select
ActiveCell.FormulaR1C1 = " "
Range("E62").Select
Range("A63:E121").Select
Selection.Copy
Range("A64").Select
ActiveSheet.Paste
Range("A63").Select
ActiveCell.FormulaR1C1 = " "
Range("B63").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D63").Select
ActiveCell.FormulaR1C1 = " "
Range("E63").Select
ActiveCell.FormulaR1C1 = " "
Range("E64").Select
Range("A65:E121").Select
Selection.Copy
Range("A66").Select
ActiveSheet.Paste
Range("A65").Select
ActiveCell.FormulaR1C1 = " "
Range("B65").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D65").Select
ActiveCell.FormulaR1C1 = " "
Range("E65").Select
ActiveCell.FormulaR1C1 = " "
Range("E66").Select
Range("A67:E121").Select
Selection.Copy
Range("A68").Select
ActiveSheet.Paste
Range("A67").Select
ActiveCell.FormulaR1C1 = " "
Range("B67").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D67").Select
ActiveCell.FormulaR1C1 = " "
Range("E67").Select
ActiveCell.FormulaR1C1 = " "
Range("E68").Select
Range("A69:E121").Select
Selection.Copy
Range("A70").Select
ActiveSheet.Paste
Range("A69").Select
ActiveCell.FormulaR1C1 = " "
Range("B69").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D69").Select
ActiveCell.FormulaR1C1 = " "
Range("E69").Select
ActiveCell.FormulaR1C1 = " "
Range("E70").Select
Range("A71:E121").Select
Selection.Copy
Range("A72").Select
ActiveSheet.Paste
Range("A71").Select
ActiveCell.FormulaR1C1 = " "
Range("B71").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D71").Select
ActiveCell.FormulaR1C1 = " "
Range("E71").Select
ActiveCell.FormulaR1C1 = " "
Range("E72").Select
Range("A73:E121").Select
Selection.Copy
Range("A74").Select
ActiveSheet.Paste
Range("A73").Select
ActiveCell.FormulaR1C1 = " "
Range("B73").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D73").Select
ActiveCell.FormulaR1C1 = " "
Range("E73").Select
ActiveCell.FormulaR1C1 = " "
Range("E74").Select
Range("A75:E121").Select
Selection.Copy
Range("A76").Select
ActiveSheet.Paste
Range("A75").Select
ActiveCell.FormulaR1C1 = " "
Range("B75").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D75").Select
ActiveCell.FormulaR1C1 = " "
Range("E75").Select
ActiveCell.FormulaR1C1 = " "
Range("E76").Select
Range("A77:E121").Select
Selection.Copy
Range("A78").Select
ActiveSheet.Paste
Range("A77").Select
ActiveCell.FormulaR1C1 = " "
Range("B77").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D77").Select
ActiveCell.FormulaR1C1 = " "
Range("E77").Select
ActiveCell.FormulaR1C1 = " "
Range("E78").Select
Range("A79:E121").Select
Selection.Copy
Range("A80").Select
ActiveSheet.Paste
Range("A79").Select
ActiveCell.FormulaR1C1 = " "
Range("B79").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D79").Select
ActiveCell.FormulaR1C1 = " "
Range("E79").Select
ActiveCell.FormulaR1C1 = " "
Range("E80").Select
Range("A81:E121").Select
Selection.Copy
Range("A82").Select
ActiveSheet.Paste
Range("A81").Select
ActiveCell.FormulaR1C1 = " "
Range("B81").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D81").Select
ActiveCell.FormulaR1C1 = " "
Range("E81").Select
ActiveCell.FormulaR1C1 = " "
Range("E82").Select
Range("A83:E121").Select
Selection.Copy
Range("A84").Select
ActiveSheet.Paste
Range("A83").Select
ActiveCell.FormulaR1C1 = " "
Range("B83").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D83").Select
ActiveCell.FormulaR1C1 = " "
Range("E83").Select
ActiveCell.FormulaR1C1 = " "
Range("E84").Select
Range("A85:E121").Select
Selection.Copy
Range("A86").Select
ActiveSheet.Paste
Range("A85").Select
ActiveCell.FormulaR1C1 = " "
Range("B85").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D85").Select
ActiveCell.FormulaR1C1 = " "
Range("E85").Select
ActiveCell.FormulaR1C1 = " "
Range("E86").Select
Range("A87:E121").Select
Selection.Copy
Range("A88").Select
ActiveSheet.Paste
Range("A87").Select
ActiveCell.FormulaR1C1 = " "
Range("B87").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D87").Select
ActiveCell.FormulaR1C1 = " "
Range("E87").Select
ActiveCell.FormulaR1C1 = " "
Range("E88").Select
Range("A89:E121").Select
Selection.Copy
Range("A90").Select
ActiveSheet.Paste
Range("A89").Select
ActiveCell.FormulaR1C1 = " "
Range("B89").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D89").Select
ActiveCell.FormulaR1C1 = " "
Range("E89").Select
ActiveCell.FormulaR1C1 = " "
Range("E90").Select
Range("A91:E121").Select
Selection.Copy
Range("A92").Select
ActiveSheet.Paste
Range("A91").Select
ActiveCell.FormulaR1C1 = " "
Range("B91").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D91").Select
ActiveCell.FormulaR1C1 = " "
Range("E91").Select
ActiveCell.FormulaR1C1 = " "
Range("E92").Select
Range("A93:E121").Select
Selection.Copy
Range("A94").Select
ActiveSheet.Paste
Range("A93").Select
ActiveCell.FormulaR1C1 = " "
Range("B93").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D93").Select
ActiveCell.FormulaR1C1 = " "
Range("E93").Select
ActiveCell.FormulaR1C1 = " "
Range("E94").Select
Range("A95:E121").Select
Selection.Copy
Range("A96").Select
ActiveSheet.Paste
Range("A95").Select
ActiveCell.FormulaR1C1 = " "
Range("B95").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D95").Select
ActiveCell.FormulaR1C1 = " "
Range("E95").Select
ActiveCell.FormulaR1C1 = " "
Range("E96").Select
Range("A97:E121").Select
Selection.Copy
Range("A98").Select
ActiveSheet.Paste
Range("A97").Select
ActiveCell.FormulaR1C1 = " "
Range("B97").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D97").Select
ActiveCell.FormulaR1C1 = " "
Range("E97").Select
ActiveCell.FormulaR1C1 = " "
Range("E98").Select
Range("A99:E121").Select
Selection.Copy
Range("A100").Select
ActiveSheet.Paste
Range("A99").Select
ActiveCell.FormulaR1C1 = " "
Range("B99").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D99").Select
ActiveCell.FormulaR1C1 = " "
Range("E99").Select
ActiveCell.FormulaR1C1 = " "
Range("E100").Select
Range("A101:E121").Select
Selection.Copy
Range("A102").Select
ActiveSheet.Paste
Range("A101").Select
ActiveCell.FormulaR1C1 = " "
Range("B101").Select
ActiveCell.FormulaR1C1 = "xxxx"
Range("D101").Select
ActiveCell.FormulaR1C1 = " "
Range("E101").Select
ActiveCell.FormulaR1C1 = " "
Range("E102").Select
ActiveWindow.SmallScroll Down:=-39
Range("E2:E103").Select
Selection.ClearContents
Range("L4:M4,L6:M6,L8:M8,L11:M11,L13:M13,L15:M15,L17:M17,L19:M19,L21:M21"). _
Select
Range("L21").Activate
Selection.ClearContents
Range("B3").Select
Application.ScreenUpdating = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub