![]() 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. 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. Follow the below steps to use the Print function in Excel VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |