VBA Print Statement in Excel

When there are many columns and rows in excel but we only want to save or print a few of them because that few rows and columns are important to us, at that case we will print them in Excel VBA so that we can fetch those details later and also to get the print out of that table because daily life hard copy of the reports is usually required in the meetings.

Syntax:

• [From]: Starting page of the printout.
• [TO]: Ending page of the printout.
• [Copies]: Number of copies of the printout.
• [Preview]: Before it gets printed if we want to view it then we can mention TRUE otherwise FALSE.

PrintOut Method Without its Parameters

Suppose, we have data as shown in the following

Now, we want to print the report from range A1 to B9. For that, we will mention the range with the PrintOut method.

Printout Method With its Parameters

Now, we will print two copies of data which will first be shown to us for that we have to assign TRUE to preview the parameter.

Parameters of Printout Method 

• Code to print the complete sheet.

• Code to print the complete sheet with its sheet name.

• Code to print all the sheets in the workbook.

• Code to print all the data in the workbook.

• Code to print the data which are selected.