Printing question

[Andrew B]

Hi
Is it possible to make Excel print two pages onto 1 ?
I print single A4 reports - sometimes it would be convenient to print
two pages onto one A4 sheet. The two pages would print onto a landscape
format page at a reduced size.(Word gives you this option when you go
through the standard print options.) I would like to know if it is
possible to do this through VBA ?

Thanks in advance

Andrew Bourke

 

[Guest]

Anything is possible but that one is tricky. The problem is that in the Excel
object model a sheet is a self contained entity. In order to print two sheet
on one page the sheets need to be mreged into a single sheet. The new sheet
then needs to be formatted to print on one page. The sheet that was created
can then be destroyed. I would recommend using worksheet objects to keep
track of things and range objects to copy and paste what you need. If the
data is always the same range size then it is not too bad to do.

 

[Andrew B]

Thanks for your help Jim.

 

[Tom Ogilvy]

In Excel, this type of functionality is a capability of the print driver and
has nothing to do with Excel directly (for example, all postscript printers
can do this). If you are asking if you can set this programmatically, there
is no built in option in Excel to do it, however, if you want to invest the
time learning how to address the printer using the windows API, it could be
done.

The other way that perhaps Jim is alluding to would be to set up another
sheet to show two pages. You would copy your ranges and paste them side by
side on this other sheet as a linked picture. You could then use the fit to
page option or otherwise arrange the page to print as you want.