PageSetup
object controls various attributes of a worksheet's pages such as paper size, margins, orientation, printing information etc. printArea
is a read/writable string that contains the address (in A1 style reference) of the range of a worksheet to be printed. ""
) in which case the entire worksheet (= .usedRange
?) will be printed. .printTitleRows
specifies one or more rows that are to be repeated when a worksheet is printed. .view
property of the window
object can be set to xlPageLayoutView
in order to make header and footer visible. PageSetup
object of Word.