Suppressing Page Break

[RichSoz]

In Lotus, I had created a macro to print two dis-similar spreadsheets onto
the same page, first over the second.

How do I suppress the page break at the bottom of the first spreadsheet, so that I can do a similar thing in Excel?

[Brian from Maui]

Rich,

Not sure if this is want you want

http://www.mrexcel.com/board/viewtop...c=6087&forum=2

[RichSoz]

Brian:
Thanks for the info, but pasting two to one sheet does not work because the columns are dis-similar.
I just need to print the first sheet and suppress the page feed to "hold the image still" while I print the second sheet.
Kind of - access to printer controls.
Rich

[Brian from Maui]

Rich,

Try the camera utility

[Yogi Anand]

On 2002-05-09 15:51, RichSoz wrote:
In Lotus, I had created a macro to print two dis-similar spreadsheets onto
the same page, first over the second.

How do I suppress the page break at the bottom of the first spreadsheet, so that I can do a similar thing in Excel?

You could try the Repoprt Manager accessed via VIEW|Report_Manager and set up a report consisting of various sections. I am not sure if it will meet your needs regarding different sections on being the same page.

And of course you can always hide the rows you do not want to print, and then print it as a continuous report.

Regards!