A Visual Basic Application (VBA) procedure is used to automate routine tasks in Microsoft Excel in order to save time. The VBA Printout Method you enter sends the documents you indicate to your default printer from your computer. Three different Printout Methods allow you to print the workbook, the worksheet or a range in the worksheet. You can use one or all of them as necessary. They are easy to enter and will save you the time of manually sending your documents to the printer.
- Skill level:
Other People Are Reading
Open the Excel file containing the procedure that you want to add the Printout Method to. Decide which of the three Printout Methods is best to use in your procedure.
Open the VBA Editor to view your procedure. A shortcut to do this is to press "Alt" and "F11." In your procedure locate the area where you want to enter the Printout Method. Usually this method is located at or near the end of the procedure.
Enter the Workbooks' Printout Method command by typing the following:
This method prints all the worksheets in the Excel workbook. Replace "Book1" in quotations with the title of your workbook.
Enter the Worksheets' Printout Method syntax as in the example. This method prints only one worksheet in the Excel workbook. However, you can enter it as many times as you have worksheets to print.
Replace Sheet 1 in quotations with the worksheet tab you want to print.
Enter the Worksheets' Range Printout Method syntax as in the example. This method prints a range, a selection of cells in a worksheet. You can enter it as many times as you have ranges to print.
Replace Sheet 1 in quotations with the worksheet tab, and replace A1:A20 with the range of cells you want to print.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for