Equivalent to clicking the Print command on the File menu. Prints the active workbook.
Arguments correspond to options, check boxes, and edit boxes in the Print dialog box. Arguments corresponding to check boxes are logical values. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box.
Syntax
PRINT(range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection)
PRINT?(range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection)
Range_num is a number specifying which pages to print.
| Range_num | Prints the following pages |
| 1 | All the pages |
| 2 | Prints a specified range. If range_num is 2, then from and to are required arguments. |
From specifies the first page to print. This argument is ignored unless range_num equals 2.
To specifies the last page to print. This argument is ignored unless range_num equals 2.
Copies specifies the number of copies to print. If omitted, the default is 1.
Draft This argument overrides the draft argument from the PAGE.SETUP function. If omitted, the Draft Setting from the Page.Setup function is used.
Preview is a logical value corresponding to the Print Preview button in the Print dialog box. If TRUE, the print preview window will be displayed. If FALSE, the window will not be displayed
Print_what is a number from 1 to 3 that specifies what parts of the sheet or macro sheet to print. If a chart is active, print_what is ignored. This argument will override the setting in the Page Setup dialog box. If omitted, the note argument in the Page.Setup function is used to determine whether to print notes or not.
| Print_what | Prints |
| 1 | Sheet only |
| 2 | Notes only |
| 3 | Sheet and then notes |
Color corresponds to the Print Using Color check box. Color is available only in Microsoft Excel for the Macintosh. If omitted, the setting is not changed.
Feed is a number specifying the type of paper feed. Feed is available only in Microsoft Excel for the Macintosh.
| Feed | Type of paper feed |
| 1 or omitted | Continuous (paper cassette) |
| 2 | Cut sheet or manual (manual feed) |
Quality Specifies the DPI output quality you want. If omitted, the corresponding settings in the Page Setup dialog box will be used. If included, this argument overrides the quality argument in the PAGE SETUP dialog box.
Y_resolution corresponds to the Print Quality box in the Page Setup dialog box if you have specified a printer where the horizontal and vertical resolution are not equal, such as a dot-matrix printer. If omitted, the corresponding settings in the Page Setup dialog box will be used. If included, this argument overrides the print quality setting in the Page Setup dialog box.
Selection specifies what portion of the sheet to print.
| Selection | Portion printed |
| 1 | Prints the current selection from all selected sheets. For example, if A1:F40 is selected on the active sheet, A1:F40 will be printed from each of the selected sheets. |
| 2 | Prints the print area or entire sheet from all selected sheets. |
| 3 | Prints print area or entire sheet from all sheets in the workbook. |
Related Functions
PAGE.SETUP Sets page printing specifications
PRINT.PREVIEW Previews pages and page breaks before printing
PRINTER.SETUP Identifies the printer
SET.PRINT.AREA Defines the print area
SET.PRINT.TITLES Defines text to print as titles
DEFINE.NAME Equivalent to clicking the Define command on the Name submenu of the Insert menu
Return to index