View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lynn[_5_] Lynn[_5_] is offline
external usenet poster
 
Posts: 3
Default Page setup for multiple pages

I want my macro to apply the same print settings to
multiple sheets in my workbook. I have tried the
following code but get an error in the first line.

With ActiveWorkbook.Worksheets(Array
("Reference", "IncomeStatement", "CashStatement
1", "CashStatement 2")).PageSetup
.PaperSize = xlPaperLegal
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With

Any suggestions are much appreciated.