Sub 拆分()
Dim I As Long, N As Long
Dim C As Long, Sh As Worksheet
Application.ScreenUpdating = False
C = Val(InputBox("请输入每个表格的行数"))
If C = 0 Then Exit Sub
Set Sh = ThisWorkbook.Worksheets(1) '要拆分的表
For I = 1 To ThisWorkbook.Worksheets(1).UsedRange.Rows.Count Step C
With ThisWorkbook.Worksheets.Add(after:=Worksheets(ThisWorkbook.Worksheets.Count))
Sh.Rows(I).Resize(C).Copy .Range("A1")
N = N + 1
.Name = N
End With
Next
Application.ScreenUpdating = True
MsgBox "共拆分出 " & N & "个工作表"
End Sub
注意修改要拆分的表名。
追问谢谢,代码怎么在宏里编写不行啊?在表里写有点麻烦,不方便工作。有没有改进啊,高手。
追答打开附件,按 ALT+F8运行。
追问不太明白,高手,可以详细些不