I am using the VBA code in below link to PDF-print an Excel sheet and send the PDF-print in e-mail.
Emailing an Excel sheet as a PDF directly
As I am weak in doing coding, I want to know how I can edit the code so that I can change the PDF-print page layout to Portrait mode and Selected Print Area.
Please help. Thanks.
I changed to True for IgnorePrintAreas but there’s no difference to the output of PDF-print.
I hope I can the PDF-Print to be in Selected Print Area and in Portrait Mode
New contributor
Simon Yip is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.