View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default Sort Worksheet Tabs

Option Explicit

Sub SortWorksheets()
Dim sCount As Integer, i As Integer, j As Integer
'Application.ScreenUpdating = False
sCount = Worksheets.Count
If sCount = 1 Then Exit Sub
For i = 1 To sCount - 1
For j = i + 1 To sCount
If Worksheets(j).Name < Worksheets(i).Name Then
Worksheets(j).Move Befo=Worksheets(i)
End If
Next j
Next i
End Sub