View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Reverse Worksheets Order

Sub reverse()
Dim i As Long

With ActiveWorkbook
For i = .Worksheets.Count - 1 To 1 Step -1
Worksheets(i).Move after:=.Worksheets(.Worksheets.Count)
Next i
End With

End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ibro Vehabovic" wrote in message
...
One file has over 50 worksheets and I would like to reverse their order.
Sharing macro to do this automatically would be greatly appreciated.

Thanks,

Ibro V.