Sub text1()
Worksheet.Add.Name="汇总"
For Each Sheet In Worksheets
k = k + 1
x = y.usedRange.Rows.Count
sheets("汇总").Cells(k, 1) = Sheet.Name
sheets("汇总").Cells(k, 2) =x
Next
End SubSub text1()
Worksheet.Add.Name="汇总"
For Each Sheet In Worksheets
k = k + 1
x = y.usedRange.Rows.Count
sheets("汇总").Cells(k, 1) = Sheet.Name
sheets("汇总").Cells(k, 2) =x
Next
End Sub