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
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