Hi.

I need to open a workbook and set the print settings for a range of
sheets in a workbook.

Sheet range - sheet 2 : sheet 6
Open sheet range in page break preview
Print range - A1:L43
type - landscape
1 page only.

(do not print - just adjust settings, and leave in page break preview)