ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Print the pages in reverse order

The macro below can be used to print the pages of a worksheet in reverse order.

Sub PrintInReverseOrder()
Dim TotalPages As Long, p As Long
    TotalPages = (ActiveSheet.HPageBreaks.Count + 1) * _
        (ActiveSheet.VPageBreaks.Count + 1)
    For p = TotalPages To 1 Step -1
        'ActiveSheet.PrintOut p, p
        Debug.Print "Printing page " & p & " of " & TotalPages
    Next p
End Sub

 

Document last updated 2000-02-04 12:50:09      Printerfriendly version

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address