VBA for Printing to PDF with selected print range based off of a Cell Value

I have some code that will print to pdf. I have some code that will print a selected range based off of a cell value but I don't know how to make it print the selected range as a pdf. I have attached a sheet as an example. I want it to print the ranges defined in the macro depending on cell "R1" to a pdf. I don't have all of the ranges defined, but this is a starter. I am The print to pdf is just code I found on the internet. Any help would be greatly appreciated.

Please Login or Register  to view this content.

Thank you very kindly. I did it a little different. I added this in and it works. Thanks again for the response.

Please Login or Register  to view this content.