【按数量拆分】
Sub Macro1()
Dim i As Integer
For i = 1 To 5
Worksheets.Add(after:=Worksheets(Worksheets.Count)).Name = "拆分" & i
Sheets("sheet1").Activate
ActiveSheet.Range(Cells((i - 1) * 20 + 1, 1), Cells(i * 20, 7)).Copy
Sheets("拆分" & i).Activate
ActiveSheet.Paste
Next
End Sub 【单独保存出来每个工作表到当前目录】
Sub fencun()
Application.ScreenUpdating = False
For each sht in thisworkbook.sheets
sht.copy
With ActiveWorkbook
.SaveAs Filename:=ThisWorkbook.Path & "\" & sht.name & ".xlsx"
.Close True
End With
Next
Application.ScreenUpdating = true
MsgBox "保存工作表完成!"