I have a workbook with 8 sheets and I planned to export all of them into single PDF file, but some sheets consist of only one page, and some of them have 2 or 3 pages to print. How to write it by using VBA? I tried to figure out some idea but all examples explained situation where multiple sheets is printed without taking in account number of pages on each sheets, is it possible?
Thank you.