SET.PRINT.AREA

Macro Sheets Only

Defines the print area for the workbook—the area that prints when you choose the Print command from the File menu. Equivalent to entering a range in the Print Area edit box on the Sheet tab in the Page Setup dialog box, which appears when you choose the Page Setup command from the File menu.

Syntax

SET.PRINT.AREA(range)

Range is the reference to the range that you want to be printed. If you specify no range by using a set of empty quotemarks (""), deletes the print area.

Remarks

• If you use SET.PRINT.AREA with a multiple selection and then use the PRINT function, the individual selections are printed one after the other in the order they were selected.
• To resume printing the entire worksheet, choose the Page Setup command from the File menu and choose the Sheet tab. Then delete the range in the Print Area edit box.

Related Functions

PRINT Prints the active workbook

SET.PRINT.TITLES Identifies text to print as titles

List of Command-Equivalent Functions