makro will nicht
21.02.2008 13:17:27
achim
mein code will nicht. wer kann verbessern?
Private Sub CommandButton18_Click()
Dim zeile As Integer
Dim zeile2 As Integer
Dim zeile3 As Integer
Dim zeile4 As Integer
Dim zeile5 As Integer
Dim zeile6 As Integer
Dim zeile7 As Integer
Dim zeile8 As Integer
Dim zeile9 As Integer
Dim zeile10 As Integer
Dim zeile11 As Integer
Dim zeile12 As Integer
zeile = 2
zeile = 3
zeile = 4
zeile = 5
zeile = 6
zeile = 7
zeile = 8
zeile = 9
zeile = 10
zeile = 11
zeile = 12
zeile2 = 3
Do Until ActiveWorkbook.Sheets("Grunddaten").Cells(zeile, 3) = 0
If ActiveWorkbook.Sheets("Grunddaten").Cells(zeile, 24) = AussuchenFürListen.TextBox2.Text _
Then
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 1) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 5)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 2) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 6)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 3) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 7)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 4) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 8)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 5) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 9)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 6) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 12)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 7) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 13)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 8) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 14)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 9) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 15)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 10) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 16)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 11) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 17)
ActiveWorkbook.Sheets("ListeLehrg").Cells(zeile2, 12) = ActiveWorkbook.Sheets(" _
Grunddaten").Cells(zeile, 18)
zeile2 = zeile2 + 1
End If
zeile = zeile + 1
Loop
Sheets("ListeLehrg").Activate
Range("A1").Select
'ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
gruss
achim h.