da ich jetzt auch schon....
14.11.2018 15:00:23
Werner
Hallo,
...was gebastelt habe:
Option Explicit
Public Sub Splitten()
Dim loLetzte As Long, i As Long, loZähler As Long
Dim loSpalte As Long, vaAnzahl As Variant
Application.ScreenUpdating = False
With Worksheets("Tabelle1")
loZähler = 1
loLetzte = .Cells(.Rows.Count, 1).End(xlUp).Row
loSpalte = .Cells(1, .Columns.Count).End(xlToLeft).Column
vaAnzahl = Application.InputBox("Splitten in Zeile xx", "Zeilenzahl", , , , , , 1)
If vaAnzahl = False Then Exit Sub
For i = 2 To loLetzte Step vaAnzahl
.Range(.Cells(1, 1), .Cells(1, loSpalte)).Copy Worksheets("Tabelle2").Range("A1")
.Range(.Cells(i, 1), .Cells(i, loSpalte)).Resize(vaAnzahl).Copy _
Worksheets("Tabelle2").Range("A2")
Worksheets("Tabelle2").Copy
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\DerDateiname_" _
& Format(loZähler, "000") & ".xlsx"
ActiveWorkbook.Close
Worksheets("Tabelle2").Cells.ClearContents
loZähler = loZähler + 1
Next i
End With
End Sub
@Rudi:
Schreibfehler
For iCounter = 1 To (.Rows.Count - 1) / anz
statt
For iCounter = 1 To (.Rows.Count - 1) / vntAnz
Gruß Werner