Sub PrintAllFirstPage()
Dim sheet As Worksheet
For Each sheet In Application.ActiveWorkbook.Worksheets
sheet.PrintOut from:=1, To:=1
Next
End Sub
you can change the page range by editing the value of from:= and to:=
May 22, 2020
How to print first page of every Excel worksheet
If you have a lot of worksheet and you would like to print all of it at the same, consider using VBA module code as follows
Subscribe to:
Posts (Atom)