Sub Macro1() Dim i As Integer For i = 1 To 100 Worksheets.Add(after:=Worksheets(Worksheets.Count)).Name = "分解" & i Sheets("sheet1").Activate ActiveSheet.Range(Cells((i - 1) * 100 + 1, 1), Cells(i * 100, 3)).Copy Sheets("分解" & i).Activate ActiveSheet.Paste Next End Sub追问