How to automate Print Zoom to fill page

P

Paul Martin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top