using Excel VBA to append a page to a PDF file

[jcswork]

or to create a PDF with more than one page ....

[Kenneth Hobson]

Welcome to the forum!

That is really two questions with two solutions.

You can record a macro to see how creating a PDF with more than one page is done. Some would do a page per worksheet. Simply select your worksheet(s) with the print ranges already set that you want, then then create the PDF. This method does order the selected worksheets by their index position though.

For the subject line solution, VBA would work with a 3rd party program to do that. Obviously, Acrobat (not the Reader), is the best one. Others might be: PDFCreator, PDFtk, PDFsam, PDFill, etc.

[jcswork]

Thanks Ken,
after a few more trails based on your advice I did realize that
you could select different ranges from same or different sheets,
before going to exportasfixedformat
and he prints them on pages one after the other to PDF,
and that is ok for my current purposes
cheers from Luxembourg;
Jean-Claude