Sub 工作表添加修改名字()
Dim wbt As Worksheet, i As Integer
For i = 1 To Worksheets.Count
Set wbt = Worksheets(i)
wbt.name = i
Next
Worksheets.Add after:=Worksheets(Worksheets.Count)
Set wbt = Worksheets(Worksheets.Count)
wbt.name = Worksheets.Count
Set wbt = Worksheets(1)
wbt.Activate
End Sub
![](http://tiebapic.baidu.com/forum/w%3D580/sign=8ba100e49235e5dd902ca5d746c7a7f5/f79acbef76094b3668ccfb5bb4cc7cd98c109de6.jpg?tbpicau=2025-02-18-05_25b5a430a885991190372e1519d7ad59)