å设ä¸å
±24å¼ è¡¨æ ¼ï¼åæ¶æAltåF11è¿å
¥å®çé¢ï¼ç¹èåçæå
¥ï¼æ¨¡åï¼ç²è´´å¦ä¸ä»£ç ï¼
Sub test()
Dim xStr As String
xStr = "U9C001U9C011U9D013U9D023U9D025U9DT02U9E001U9E002U9E003U9E004U9F006U9F201U9F202U9H001U9H008U9HB02U9HB05U9HB08U9J101U9J102U9J103U9K001U9KC01U9L004"
Dim i As Integer
For i = 1 To 24
Sheets(i).Name = Mid(xStr, i * 6 - 5, 6)
Next i
End Sub
å¨æ¤çé¢ç´æ¥æF5è¿è¡æ¤å®ï¼å®æã
温馨提示:答案为网友推荐,仅供参考