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.
Example
This example prints the active sheet.
ActiveSheet.PrintOut