|
Private Sub CommandButton1_Click()
k = Sheets(1).Range("A65536").End(xlUp).Row
For i = 1 To k
If Sheets(1).Cells(i, 1) <> Sheets(1).Cells(i + 1, 1) Then
Worksheets.Add after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = "表" & Worksheets.Count - 1
kx = 1
ActiveSheet.Cells(kx, 1) = Sheets(1).Cells(1, 1)
ActiveSheet.Cells(kx, 2) = Sheets(1).Cells(1, 2)
ActiveSheet.Cells(kx, 3) = Sheets(1).Cells(1, 3)
ActiveSheet.Cells(kx, 4) = Sheets(1).Cells(1, 4)
ActiveSheet.Cells(kx, 5) = Sheets(1).Cells(1, 5)
ActiveSheet.Cells(kx, 6) = Sheets(1).Cells(1, 6)
kx = 2
ActiveSheet.Cells(kx, 1) = Sheets(1).Cells(i + 1, 1)
ActiveSheet.Cells(kx, 2) = Sheets(1).Cells(i + 1, 2)
ActiveSheet.Cells(kx, 3) = Sheets(1).Cells(i + 1, 3)
ActiveSheet.Cells(kx, 4) = Sheets(1).Cells(i + 1, 4)
ActiveSheet.Cells(kx, 5) = Sheets(1).Cells(i + 1, 5)
ActiveSheet.Cells(kx, 6) = Sheets(1).Cells(i + 1, 6)
Else
ActiveSheet.Cells(kx, 1) = Sheets(1).Cells(i + 1, 1)
ActiveSheet.Cells(kx, 2) = Sheets(1).Cells(i + 1, 2)
ActiveSheet.Cells(kx, 3) = Sheets(1).Cells(i + 1, 3)
ActiveSheet.Cells(kx, 4) = Sheets(1).Cells(i + 1, 4)
ActiveSheet.Cells(kx, 5) = Sheets(1).Cells(i + 1, 5)
ActiveSheet.Cells(kx, 6) = Sheets(1).Cells(i + 1, 6)
End If
kx = kx + 1
Next
End Sub |
|