ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro to print the first two pages of every tab in excel? (https://www.excelbanter.com/excel-programming/357509-macro-print-first-two-pages-every-tab-excel.html)

Felipe

macro to print the first two pages of every tab in excel?
 
please help !

JE McGimpsey

macro to print the first two pages of every tab in excel?
 
One way:

Public Sub PrintFirstTwoPagesOfEachWorksheet()
Dim ws As Worksheet
For Each ws In Worksheets
ws.PrintOut From:=1, To:=2
Next ws
End Sub

In article ,
Felipe wrote:

please help !



All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com