Thread: macro to print the first two pages of every tab in excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default 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 !
Reply With QuoteReply With Quote