Need to choose range for .pdf email attachment and scale to a single page

Hello,

I've written some vba code to trigger when an active x button is pressed. Pretty standard e-mail code. It also makes a pdf of the active worksheet and attaches it to the email.
I would like to restrict the pdf to the range (a1:s49) while also scaling to a single page.

Please Login or Register  to view this content.

Any help is greatly appreciated.

Cheers,

Try inserting the below code before: ChDir "C:\Alexa"

Please Login or Register  to view this content.