Hello rbanks
AFAIK apart from looping through each worksheet?
Dim wsh As Worksheet
For Each wsh In ThisWorkbook.Worksheets
With wsh.PageSetup
..CenterFooter
..LeftMargin
..PrintArea
..PrintTitleRows
'so on...
End With
Next wsh

HTH
Cordially
Pascal

"rbanks" a écrit dans
le message de news: ...

I have a workbook that has several hundred sheets, that all need exactly
the same print settings.

Is there a way to set up one sheet with page breaks, margins, print
compression, rows repeated at top, headers, footers, etc.. and copy
those to each sheet in the workbook?


--
rbanks
------------------------------------------------------------------------
rbanks's Profile:
http://www.excelforum.com/member.php...fo&userid=2944
View this thread: http://www.excelforum.com/showthread...hreadid=521754