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

Jim Thomlinson


"Andrew B" wrote:

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