wie kann man folgendes lösen
Range("AA1:AF1").Select: Selection.Copy
Range("B23").Select : ActiveSheet.Paste
Range("AH1").Select: Selection.Copy
Range("E24").Select:ActiveSheet.Paste
Range("AA2:AF2").Select: Selection.Copy
Range("B24").Select : ActiveSheet.Paste
Range("AH2").Select: Selection.Copy
Range("E26").Select:ActiveSheet.Paste
Diese Aktion soll solange durchgeführt werden bis in
Range("AA") keine Daten mehr sind
Mein Code scheitert kläglich
Sub Makro1()
Dim iRowL As Integer, iRow As Integer, I As Integer
Dim Range As Variant
iRowL = Sheets("Tabelle1").Cells(Rows.Count, 27).End(xlUp).Row
For I = 1 To iRowL
Range = Sheets("Tabelle1").Cells(23, 2)
iRow = Sheets("Tabelle1").Cells(1, 27).End(xlUp).Row + 1
Rows.Copy
Range.Rows (iRow)
Application.CutCopyMode = False
Call Makro2
Next I
End Sub
Sub Makro2()
Dim iRowL As Integer, iRow As Integer, I As Integer
Dim Range As Variant
iRowL = Sheets("Tabelle1").Cells(Rows.Count, 34).End(xlUp).Row
For I = 1 To iRowL
Range = Sheets("Tabelle1").Cells(24, 4)
iRow = Sheets("Tabelle1").Cells(1, 34).End(xlUp).Row + 1
Rows.Copy
Range.Rows (iRow)
Application.CutCopyMode = False
Next I
End Sub
Für jeder Hilfe danke!
Gruß
crissi