How to: Print Worksheets
Some code examples in this topic use the this or Me keyword or the
Themethod enables you to print the specified object. You can include a number of optional parameters, including a range of pages to print, the number of copies, whether you want to preview before printing, the name of the printer to use, whether you want to print to a file, whether you want to collate, and the name of the file you want to print to.
To print a worksheet
Call the PrintOut method of
Sheet1, request two copies, and preview the document before printing.