Charts.PrintOut Method
| Excel Developer Reference |
Prints the object.
Syntax
expression.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName, IgnorePrintAreas)
expression A variable that represents a Charts 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.
| Visual Basic for Applications |
|---|
|
See Also