Public Sub title()
Dim i As Integer
Dim CountSht As Integer
Dim CountRow As Integer
CountSht = Sheets.Count
For i = 1 To CountSht
Sheets(i).Activate
CountRow = Cells(Rows.Count, 1).End(3).Row
Columns(1).Select
Selection.Insert
Cells(1, 1).Value = "工作表名称"
Range(Cells(2, 1), Cells(CountRow, 1)).Value = ActiveSheet.Name
Next i
End Sub
Public Sub title()
Dim i As Integer
Dim CountSht As Integer
CountSht = Sheets.Count
For i = 1 To CountSht
Sheets(i).Activate
Columns(1).Select
Selection.Insert
Cells(1, 1).Value = "工作表名称"
Cells(2, 1).Value = ActiveSheet.Name
Next i
Public Sub title()
Dim i As Integer
Dim CountSht As Integer
Dim CountRow As Integer
CountSht = Sheets.Count
For i = 1 To CountSht
Sheets(i).Activate
CountRow = Cells(Rows.Count, 1).End(3).Row
Columns(1).Select
Selection.Insert
Cells(1, 1).Value = "工作表名称"
Range(Cells(2, 1), Cells(CountRow, 1)).Value = ActiveSheet.Name
Next i
End Sub