Excel wird langsam
29.04.2009 10:05:15
Felix
Ich habe aus anderen Makros ein Makro zusammen kopiert, das im Prinzip macht was ich will. Nur leider ist seitdem das Arbeiten in dem Excel sheet, in dem das Makro ist, unglaublich langsam. Alle anderen sheets (über 40 in dem workbook) laufen einwandfrei, auch das Laden der Datei geht zügig.
Es geht mir in diesem Fall nicht um die Laufzeit des Markos, sondern darum, dass Excel selbst so langsam ist (kopieren/ verschieben von Zellen etc.)
Was kann ich ändern an diesem Code bzw woran könnte es noch liegen? Vielen Dank für die Hilfe
Sub heli()
Worksheets("data").Range("a1:a850").Copy Destination:= _
Worksheets("heli").Range("c4:C853")
Worksheets("data").Range("b1:b850").Copy Destination:= _
Worksheets("heli").Range("d4:d853")
Worksheets("data ").Range("b1:b850").Copy Destination:= _
Worksheets("heli").Range("k4:k853")
'copy current percentages
Select Case Sheets("heli").Cells(2, 17).Value
Case "01/01/2009"
Worksheets("data").Range("c1:c850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/02/2009"
Worksheets("data").Range("d1:d850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/03/2009"
Worksheets("data").Range("e1:e850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/04/2009"
Worksheets("data").Range("f1:f850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/05/2009"
Worksheets("data").Range("g1:g850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/06/2009"
Worksheets("data").Range("h1:h850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/07/2009"
Worksheets("data").Range("i1:i850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/08/2009"
Worksheets("data").Range("j1:j850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/09/2009"
Worksheets("data").Range("k1:k850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/10/2009"
Worksheets("data").Range("l1:l850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/11/2009"
Worksheets("data").Range("m1:m850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
Case "01/12/2009"
Worksheets("data").Range("n1:n850").Copy Destination:= _
Worksheets("heli").Range("f4:f853")
End Select
Select Case Sheets("heli").Cells(2, 16).Value
Case "01/01/2009"
Worksheets("data").Range("c1:c850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/02/2009"
Worksheets("data").Range("d1:d850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/03/2009"
Worksheets("data").Range("e1:e850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/04/2009"
Worksheets("data").Range("f1:f850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/05/2009"
Worksheets("data").Range("g1:g850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/06/2009"
Worksheets("data").Range("h1:h850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/07/2009"
Worksheets("data").Range("i1:i850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/08/2009"
Worksheets("data").Range("j1:j850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/09/2009"
Worksheets("data").Range("k1:k850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/10/2009"
Worksheets("data").Range("l1:l850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/11/2009"
Worksheets("data").Range("m1:m850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
Case "01/12/2009"
Worksheets("data").Range("n1:n850").Copy Destination:= _
Worksheets("heli").Range("e4:e853")
End Select
Select Case Sheets("heli").Cells(2, 17).Value
Case "01/01/2009"
Worksheets("data ").Cells(i, 3).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/02/2009"
Worksheets("data ").Cells(i, 4).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/03/2009"
Worksheets("data ").Cells(i, 5).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/04/2009"
Worksheets("data ").Cells(i, 6).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/05/2009"
Worksheets("data ").Cells(i, 7).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/06/2009"
Worksheets("data ").Cells(i, 8).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/07/2009"
Worksheets("data ").Cells(i, 9).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/08/2009"
Worksheets("data ").Cells(i, 10).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/09/2009"
Worksheets("data ").Cells(i, 11).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/10/2009"
Worksheets("data ").Cells(i, 12).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/11/2009"
Worksheets("data ").Cells(i, 13).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
Case "01/12/2009"
Worksheets("data ").Cells(i, 14).Copy Destination:= _
Worksheets("heli").Cells(i + 3, 12)
End Select
MsgBox ("copied")
End Sub