VBA Schleife
24.05.2016 15:56:01
Michael
wie könnte ich daraus eine Schleife machen?
Sheets("Sheets2").Range("A2") = Sheets("Sheet1").Range("A" & maxRow) _
& ";" & Sheets("Sheet1").Range("B" & maxRow) _
& ";" & Sheets("Sheet1").Range("C" & maxRow) _
& ";" & Sheets("Sheet1").Range("D" & maxRow) _
& ";" & Sheets("Sheet1").Range("E" & maxRow) _
& ";" & Sheets("Sheet1").Range("F" & maxRow) _
& ";" & Sheets("Sheet1").Range("G" & maxRow) _
& ";" & Sheets("Sheet1").Range("H" & maxRow) _
& ";" & Sheets("Sheet1").Range("I" & maxRow) _
& ";" & Sheets("Sheet1").Range("J" & maxRow) _
& ";" & Sheets("Sheet1").Range("K" & maxRow) _
& ";" & Sheets("Sheet1").Range("L" & maxRow) _
& ";" & Sheets("Sheet1").Range("M" & maxRow)
Gruß,Michael