How to automate Print Zoom to fill page
 

Hi guys

I have written some code that prints combinations of embedded charts.
The code ascertains the TopLeftCell and BottomRightCell ranges in
order to set the print range. When I print, I set the PageSetup to
FitToPagesWide=1 and FitToPagesTall=1. So far, so good. If a print
job is too big, it fits to the page.

What I can't work out, is when the print job is smaller than what
fills a page, I would like to automatically adjust the zoom to fill
the page. I know how to do this to screen, but not with a print job.
Any suggestions?

Thanks in advance

Paul Martin
Melbourne, Australia