In case we do not enter the above-mentioned command, the following message displays while execution. Unless we enter this command, the arguments are considered incomplete. Step 10: To end the command we need to enter “End Sub”. But we can customize this option also, if necessary.Ī copies:=1, collate:= True, IgnorePrintAreas:= False End Sub Step 9: We have also mentioned “Ignore print areas” because we have only 1 sheet to print and that is well within the ambit of Print areas. In the above function,Ī copies:=1, collate:= True End Sub By inputting “ Collate _:=True” function we ensure that the data is composed together in the sheet. Step 8: The next argument is “ Collate” function. We can customize it based on a number of copies we need to print. But we can also modify the details like 2 or 3 copies if required. Step 8: After putting the “Printout” option, we select the number of copies in the argument.Ī copies:=1įor instance, in our example, we have mentioned “ Copies=1”. Step 7: Then we have to use “ Printout” option in VBA which appears on the screen. The command “Selected Sheets” denotes that the same data has been copied from the source sheet where data is mentioned. Step 6: The first command is the source data which we have mentioned as Macro1. Step 5: Now let us start writing the code, to do that we need to name the macro first as follows, The subject shall start with command “Sub- Print1 ()” since the information database is taken from Macro1 which we created in Step 2.
#Quick print excel code
Step 4: Once we are in VBA we need to insert a module so that we can write code in it. For getting the option on Excel, we need to follow the instruction as follows: Click on Developer’s tab then click on Visual Basic to get into VBA. The Print function can be used in VBA with the help of a Developer option.
Once the Macro is created we can proceed with creating the Print option. In the present case, we have kept the name of our Macros as “ Macro1” which is a default name provided. Select the Data- View-Macros – Record Macro.Īs soon as we put this option, we get the below mentioned screen. It is usually created as a shortcut to a large volume of data.įollow the below steps to use the Print function in Excel VBA. A Macro is generally created for ease of access to data. However, for making a VBA Print function work properly, we first need to create a Macro. Like the above, we have such options in VBA also, with advanced features. To print the above, we need to have a printer added to our computer/ laptop and we can directly print the above data by going to File-Print. We have the following data of several companies with details of Revenue, Expenses, Profit and percentage of profit on Revenue.
#Quick print excel download
You can download this VBA Print Excel Template here – VBA Print Excel Template VBA Print – Example #1