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.