» Print the pages in reverse order using VBA in Microsoft Excel
VBA macro tip contributed by Erlandsen Data Consulting offering Microsoft Excel Application development, template customization, support and training solutions
CATEGORY - Printing in VBA
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Fall of Advertising and the Rise of PR
- Financial Statement Analysis with S&P insert card
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
No comments have been submitted.
