Possible vba export specific sheets to pdf with range selection

Hi to All,

My example workbook is attached. In my original there are 5 contstants (3 of them are hided) and various number (may lead to 200 sheets) of sheets after 5 constants. What I want to realize is to export specific sheets from 2nd to the last one in a single pdf file with range selection starting from 5th row to last used cell can be seen in attachment . My constant sheets string:

1st Sheet name “CALC” (Unhide)
2nd Sheet name “INDEX” (Unhide)
3rd Sheet name “HELPER1” (Hide)
4th Sheet name “HELPER2” (Hide)
5th Sheet name “HELPER3” (Hide)

The rest of the Sheets starting after "HELPER3" have different names of Hotels.

Thanks in advance for your kindest helps.

I have supported with the code below and works fine to create seperate pdf output but not succeded to save as single pdf file. How can the code altered to save each pages in single pdf file not seperate? Thanks in advance for helps.

Please Login or Register  to view this content.

Dear Alan,

This query was only sent to Chandoo Excel Forum site nomore other sites. The link of the query: https://chandoo.org/forum/threads/ne...-to-pdf.41586/

Best Regards

Dear Alan,
One more thanks for your support. I compiled your code with your referenced web site code as in below, now works fine.
Regards

Please Login or Register  to view this content.