Need Header to be saved to each file and have it saved to same folder not my desk top other than those it works spliting them into 100 rows per new file.
Sub t()
Dim i As Long
With ActiveSheet
For i = 1 To .Cells(Rows.Count, 1).End(xlUp).Row Step 100
Workbooks.Add
.Rows(i).Resize(100).Copy
ActiveWorkbook.Sheets(1).Range("A1").PasteSpecial xlPasteValuesAndNumberFormats
ActiveWorkbook.SaveAs "Split" & i & ".xlsx", FileFormat:=51
ActiveWorkbook.Close False
Next
End With
End Sub
Bookmarks