Sub reverse_sheet_order()
Dim TotalSheets As Integer
TotalSheets = ActiveWorkbook.Sheets.Count
For i = 1 To TotalSheets
Sheets(TotalSheets).Move before:=Sheets(i)
Next
End Sub
This macro is used to reverse the order of sheets in Active workbook. Rerun the macro to get the original order of sheets.
Friday, December 31, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment