Hello,

I am struggling to write some code to save three worksheets in a particular order to a single pdf file with each worksheet along with the ranges assigned. These 3 worksheets are among 60 worksheets in a single Workbook. There are pdf codes out there but not with getting the exact order and the required range.

Example:

Name of Sheet1 -> “TitlePage’ Range(“A1:D25”)
Name of Sheet2-> “DataPage” Range(myrange) where myrange is a variable
Name of Sheet3-> “Summary” Range(“A1:F24”) where myrange is a variable

I wanted to save these 3 worksheets in the exact order with the ranges above
to a single pdf file. Thank you for any direction.