in reply to Re^2: Excel saving as PDF as 1 page
in thread Excel saving as PDF as 1 page

This: http://www.mrexcel.com/forum/excel-questions/311404-visual-basic-applications-page-setup-fit-1-1-a.html says you have to set ->{Zoom} to False, but in other situations that property is a numeric zoom factor, so I'd set it to zero.

As for the why, I surmise the zoom factor has higher priority than the "Fit to Page" setting.

Replies are listed 'Best First'.
Re^4: Excel saving as PDF as 1 page
by merrymonk (Hermit) on Oct 25, 2015 at 09:24 UTC
    (This is a reply to your latest comment)
    Brilliant. That works just as I wanted it to. Thank you for your help. It was good to find it first thing this morning.
[reply]

In Section Seekers of Perl Wisdom