View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Sort Worksheet Tabs

Try this

Sub sortem()
For a = 1 To Sheets.Count - 1
For b = a + 1 To Sheets.Count
If (Sheets(a).Name) (Sheets(b).Name) Then
Sheets(b).Move Befo=Sheets(a)
End If
Next b
Next a
End Sub

Mike

"Beep Beep" wrote:

I have a bunch of tabs and the name's are numbers. Any way to sort the tabs
with a macro.

Thanks
Frank