Use the function to retrieve the number of pages that you'll have to print, if it is required. The function will return the number of pages needed to print the sheets. This function accepts both the OptionalVariant and the Number parameter. OptionalVariant is the optional value you want to return when a Sheet has not enough pages that you'll have to print. OptionalVariant: 'None' If this parameter is omitted, an error is returned. Number(Optional Variant): One of [0-99] If this parameter is omitted, an error is returned. Dec 12, 2023 — Print multiple Sheets using VBA macro now; Excel Macros — ExcelHowto 2. Print Specific Sheets by Sheet Number Using VBA Macro Now, you can print multiple sheets using the sheet number. But this method will print Excel Form to Print & Copy Multiple Sheets First, you need to create a form that has the properties of both fields: Filename and Hostname: Filename {1} {2} Hostname {1} {2} If you want to include a unique Number parameter, you will need to specify this when you call. Form2(). You'll want to call. Form2() instead of. Form() because the properties of the Form do not include. NumericForms in this example. Now, when you use the form properties (filename and hostname) when you call. Form1() a different copy of the spreadsheet will be returned. Filename {#{3}} Hostname {#{3}} Form1 {#{2}} Form2 {#{1}} Apr 15, 2023 — Now, you have two ways to select the sheets to print using VBA: Set Sheena(filename, hostname) on the First Sheet; Set Sheena(filename, hostname) on Multiple Sheets; Excel-Sheet Duplication Tips by VBA Macro NameRequired/OptionalData typeFromOptionalVariantToOptionalVariantCopiesOptionalVariant. You can find this in the VBA-Macro. Set this option if you want to require a key for each sheet. The macro will use the key that is associated with each sheet when creating the form. You can give the key a value (optional). This will require you to enter that value using the key.