Public Sub 更改名称()
For i = 2 To Worksheets.Count
Worksheets(i).Name = Worksheets("目录").Cells(i, 2).Value
Next
End Sub
Excel VBA 根据单元格内容更改工作表名称
最新推荐文章于 2024-06-18 09:47:08 发布
Public Sub 更改名称()
For i = 2 To Worksheets.Count
Worksheets(i).Name = Worksheets("目录").Cells(i, 2).Value
Next
End Sub