如题所述
Sub 获取工作表名称
Dim ws As Worksheet
Dim i As Integer
i = 1
For Each ws In ThisWorkbook.Worksheets
Sheets("Sheet1").Cells(i, 2).Value = ws.Name
Next ws
End Sub
Dim ws As Worksheet
Dim i As Integer
i = 1
For Each ws In ThisWorkbook.Worksheets
Sheets("Sheet1").Cells(i, 2).Value = ws.Name
Next ws
End Sub
温馨提示:答案为网友推荐,仅供参考