Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to reverse the order of dozens of pages in an Excel workbook. I would
appreciate any advice. Thanks! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If by "pages" you mean (work)sheets, the following macro will
do the trick (assuming no hidden sheets) Sub ReverseSheets() Dim s As Object, i As Integer, iNumSheets As Integer iNumSheets = ActiveWorkbook.Sheets.Count For i = 1 To iNumSheets Set s = ActiveWorkbook.Sheets(1) s.Move after:=ActiveWorkbook.Sheets(iNumSheets - i + 1) Next End Sub vlm wrote: I need to reverse the order of dozens of pages in an Excel workbook. I would appreciate any advice. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
over, then down feature under page order in Excel | Excel Discussion (Misc queries) | |||
HOW DO I CHANGE THE ORDER OF THE SHEETS IN EXCEL WORKBOOK? | New Users to Excel | |||
Is it possible to print the pages of a workbook in reverse order? | Excel Discussion (Misc queries) | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
Open excel from htm page | Excel Discussion (Misc queries) |