|
按住Alt不放 依次按f11 、I、M 会弹出一个插件编辑框 将下面代码复制进去运行即可!!可以将工作表按顺序排列
Sub test()
Dim s As Worksheet
Dim n() As String
t = ThisWorkbook.Sheets.Count
ReDim n(1 To t)
For i = 1 To t
n(i) = Sheets(i).Name
Next
For i = 1 To t - 1
For j = i + 1 To t
If n(i) > n(j) Then
a = n(i)
n(i) = n(j)
n(j) = a
End If
Next
Next
For i = 1 To t
Sheets(n(i)).Move Sheets(i)
Next
End Sub
|
|