Updated : Dec 28, 2019 in Công Nghệ✅

Đổi tên hàng loạt sheets trong Excel



Đoạn mã cần copy:

Sub RenamingSheets()
nmbr = InputBox(“What’s the first number you want to name the sheets?”, “Renaming Sheets”)
For ws = 1 To Worksheets.Count
Sheets(ws).Name = “Ten-sheet-” & nmbr
nmbr = nmbr + 1
Next ws
End Sub

Nguồn: https://dungquatiz.com/

Xem thêm bài viết khác: https://dungquatiz.com/category/cong-nghe/

Leave a Reply

Your email address will not be published. Required fields are marked *