Tom’s Tutorials For Excel: Printing Some Sheets, Not Printing Others
In some cases you want an easy way to print only certain sheets from your workbook.
There are two approaches — identifying which sheets to include, or which sheets to exclude.
Below are two macros, one showing an example for inclusion and the other for exclusion.
Sub PrintInclude() Dim i%, mySheets As Variant mySheets = (Array("Sheet1", "Sheet3", "Sheet8", "Sheet14")) For i = LBound(mySheets) To UBound(mySheets) Worksheets(mySheets(i)).PrintOut Next i End Sub
Sub PrintExclude() Dim ws As Worksheet For Each ws In Worksheets If ws.Name <> "Sheet1" And ws.Name <> "Sheet2" Then ws.PrintOut Next ws End Sub