对所有工作表排序,百分百有效!
工具->宏,新建,将以下代码粘贴在空白处,保存,关闭;
工具->宏;选择新建的宏,确定运行。
Sub Sort()
If MsgBox("Sort Sheet??", vbYesNo, "Message") = vbYes Then
Dim wbook As Workbook
Dim wsheet As Worksheet
Dim i As Integer
Dim countsh As Integer
Dim ss() As String
Set wbook = ActiveWorkbook
countsh = wbook.Sheets.Count
ReDim ss(1 To countsh)
For i = 1 To countsh
ss(i) = wbook.Sheets(i).Name
Next
Set wsheet = wbook.Worksheets.Add
For i = 1 To countsh
wsheet.Cells(i, 1).Value = ss(i)
Next
wsheet.Columns(1).Sort Key1:=wsheet.Columns(1), Order1:=xlAscending
For i = 1 To countsh
ss(i) = wsheet.Cells(i, 1).Value
Next
Application.DisplayAlerts = False
wsheet.Delete
Application.DisplayAlerts = True
For i = 1 To countsh
wbook.Sheets(ss(i)).Move after:=wbook.Sheets(countsh)
Next
Else: MsgBox "ok!"
End If
End Sub
温馨提示:答案为网友推荐,仅供参考