Sheets.PrintOut Method (Excel)
Prints the object.
Syntax
expression . PrintOut( From , To , Copies , Preview , ActivePrinter , PrintToFile , Collate , PrToFileName , IgnorePrintAreas )
expression A variable that represents a Sheets object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| From | Optional | Variant | The number of the page at which to start printing. If this argument is omitted, printing starts at the beginning. |
| To | Optional | Variant | The number of the last page to print. If this argument is omitted, printing ends with the last page. |
| Copies | Optional | Variant | The number of copies to print. If this argument is omitted, one copy is printed. |
| Preview | Optional | Variant | True to have Microsoft Excel invoke print preview before printing the object. False (or omitted) to print the object immediately. |
| ActivePrinter | Optional | Variant | Sets the name of the active printer. |
| PrintToFile | Optional | Variant | True to print to a file. If PrToFileName is not specified, Microsoft Excel prompts the user to enter the name of the output file. |
| Collate | Optional | Variant | True to collate multiple copies. |
| PrToFileName | Optional | Variant | If PrintToFile is set to True , this argument specifies the name of the file you want to print to. |
| IgnorePrintAreas | Optional | Variant | True to ignore print areas and print the entire object. |
Return Value
Variant
Remarks
"Pages" in the descriptions of From and To refers to printed pages ? not overall pages in the sheet or workbook.
Examples
Prints Active Sheet
ActiveSheet.PrintOut
Prints from Page X to Page Y
Prints from page 2 to page 3.
Worksheets. ("sheet1").PrintOut From:=2, To:=3
Prints 3 Copies
Prints three copies from page 2 to page 3.
Worksheets. ("sheet1").PrintOut From:=2, To:=3, Copies:=3