How to only print the last page of a worksheet in Excel?
In many cases, you may just need print the last page of a worksheet in Excel. How to get it done? This article provides a solution to achieve it.
Recommended Excel Productivity Tools
You can run the following VBA code to only print the last page of a worksheet in Excel. Please do as follows.
1. Open the worksheet you just need to print the last page, then press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, click Insert > Module. Then copy and paste the below VBA code into the Module window.
VBA code: Only print the last page of a worksheet
Sub PrintLastPage() Dim xPages As Long xPages = ActiveSheet.PageSetup.Pages.Count If xPages > 0 Then ActiveSheet.PrintOut from:=xPages, to:=xPages, preview:=True End Sub
3. Press the F5 key to run the code, then the last page of current worksheet is displayed in the popping up Print Preview dialog box. Please click the Print button to start printing. See screenshot: